Wednesday, September 19, 2018

Bundle V4.6 Is Released

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