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
التنظيف المثالي للتنظيف بجازان
السفير المثالي للتنظيف بالدمام
الفارس المثالي للخدمات المنزلية في حائل
شركة الطائي للتنظيف بحائل
شركة الامانة للتنظيف بحائل
شركة النخيل للتنظيف بحائل
Erro CBD with script sql_id_details.sh , version 1.6 is OK .
grep: 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:
—————————