The July release of DBA Bundle is now available:
https://www.dropbox.com/s/k96rl0f4g39ukih/DBA_BUNDLE5.tar?dl=0
The new features include:
- Adding Execution Plan History and enhancing the output formatting for sql_id_details.sh script for showing the details/execution plan/history of a SQL statement.
- Enhanced locating listener's log and bdump logs in oracle_cleanup.sh for cleaning DB logs.
- Enhanced the check of backup location validity in RMAN_full.sh script for taking on-demand DB backup.
- Adding multipath setting to the configuration baseline log in configuration_baseline.sh script which save the details of DBs and server configurations.
- Enhanced the 12c compatibility of dbdailychk.sh which creates health check report for the database.
- Exclude golden gate processes from the long-running queries reporting in
dbdailychk.sh and active_sessions.sh scripts.
- Added the options of modifying the backup tag, overwrite the last backup in schedule_rman_full_bkp.sh which can be configured to perform a regular database full backup.
- Minor functionality enhancements and bug fixes in the following scripts:
export_data.sh For exporting data.
rebuild_table.sh For rebuilding tables online.
oradebug.sh For gathering an oradebug report.
For more reading on how to use the DBA Bundle:
http://dba-tips.blogspot.com/2014/02/oracle-database-administration-scripts.html
https://www.dropbox.com/s/k96rl0f4g39ukih/DBA_BUNDLE5.tar?dl=0
The new features include:
- Adding Execution Plan History and enhancing the output formatting for sql_id_details.sh script for showing the details/execution plan/history of a SQL statement.
- Enhanced locating listener's log and bdump logs in oracle_cleanup.sh for cleaning DB logs.
- Enhanced the check of backup location validity in RMAN_full.sh script for taking on-demand DB backup.
- Adding multipath setting to the configuration baseline log in configuration_baseline.sh script which save the details of DBs and server configurations.
- Enhanced the 12c compatibility of dbdailychk.sh which creates health check report for the database.
- Exclude golden gate processes from the long-running queries reporting in
dbdailychk.sh and active_sessions.sh scripts.
- Added the options of modifying the backup tag, overwrite the last backup in schedule_rman_full_bkp.sh which can be configured to perform a regular database full backup.
- Minor functionality enhancements and bug fixes in the following scripts:
export_data.sh For exporting data.
rebuild_table.sh For rebuilding tables online.
oradebug.sh For gathering an oradebug report.
For more reading on how to use the DBA Bundle:
http://dba-tips.blogspot.com/2014/02/oracle-database-administration-scripts.html
Erro CBD with script sql_id_details.sh , version 1.6 is OK .
ReplyDeletegrep: CDBSOE1: No such file or directory
Usage: pgrep [-flvx] [-d DELIM] [-n|-o] [-P PPIDLIST] [-g PGRPLIST] [-s SIDLIST]
[-u EUIDLIST] [-U UIDLIST] [-G GIDLIST] [-t TERMLIST] [PATTERN]
Usage: pwdx pid...
Enter the SQL_ID:
================
<<< The Provided SQLID is NOT found in v$SQL view! >>>
Please Enter a Valid SQLID:
---------------------------