The new features of Bundle V4.6 are:
db_locks.sh script: Replaced the column that checks the wait in seconds from SECONDS_IN_WAIT to use WAIT_TIME_MICRO (which is more accurate) for 11gr2 compatibility.
dbalarm.sh script:
- The BLOCKING SESSION time threshold has been changed so the script will monitor only the blocking sessions that are blocked for more than 1 min.
- For 11g version onwards, The BLOCKING SESSION time threshold will be compared against WAIT_TIME_MICRO column which is more accurate.
sql_id_details.sh script: If the statement was already been vetted by SQL Advisor, the script will automatically show the tuning recommendations.
To download DBA Bundle V4.6:
https://www.dropbox.com/s/xn0tf2pfeq04koi/DBA_BUNDLE4.tar?dl=0
To visit the main article that explains all the bundle's features:
http://dba-tips.blogspot.com/2014/02/oracle-database-administration-scripts.html
db_locks.sh script: Replaced the column that checks the wait in seconds from SECONDS_IN_WAIT to use WAIT_TIME_MICRO (which is more accurate) for 11gr2 compatibility.
dbalarm.sh script:
- The BLOCKING SESSION time threshold has been changed so the script will monitor only the blocking sessions that are blocked for more than 1 min.
- For 11g version onwards, The BLOCKING SESSION time threshold will be compared against WAIT_TIME_MICRO column which is more accurate.
sql_id_details.sh script: If the statement was already been vetted by SQL Advisor, the script will automatically show the tuning recommendations.
To download DBA Bundle V4.6:
https://www.dropbox.com/s/xn0tf2pfeq04koi/DBA_BUNDLE4.tar?dl=0
To visit the main article that explains all the bundle's features:
http://dba-tips.blogspot.com/2014/02/oracle-database-administration-scripts.html
