Monday, November 23, 2020

DBA Bundle 6.0

 The 6th version of DBA Bundle is now available:

https://www.dropbox.com/s/llj0n4qr4puyinp/DBA_BUNDLE6.tar?dl=0

After opening the link click on the Down Arrow on the right side:




The new features include:

sql_tune.sql script can display the SQL PLAN BASELINE Details for SQL statement. It allows the user to fix an EXECUTION PLAN by creating a new BASELINE. Also enables the user to fix an EXECUTION PLAN inside an already exist BASELINE.

monitor_audit_records.sh script can report audit records on SYS.AUD$ table including failed login attempts and DMLs/DDLs. The user can control the activities that can be reported. It will recommend the user to create an index on sys.idx_ntimestamp# in order to boost the execution time of the script.

db_locks.sh script can show the locks in the database in a user-friendly output.

unlock_user.sh script can reset a user's password using enhanced password algorithm.

Minor updates and bug fixes added to the following scripts:

dbdailychk.sh ... Generates daily health check report for databases

aliases_DBA_BUNDLE.sh ... Setup aliases for the bundle's scripts in the environment

export_data.sh ... export data

oradebug.sh ... generate an Oradebug report

parameter_val.sh ... show the value of a visible/hidden parameter or for all non-default parameters.

 

In case you are new to the DBA Bundle, please visit below link to understand its functions and how it works:
http://dba-tips.blogspot.com/2014/02/oracle-database-administration-scripts.html