The 6th version of DBA Bundle is now available:
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: