If your busy DBA career left you living under a rock for the last few days, let me remind you that the new bundle version 4.1 is now released with the following enhancements:
Three new scripts:
backup_ctrl_spf_AWR.sh
kill_long_running_queries.sh
check_standby_lag.sh
New features/bug fixes for already exist scripts:
RMAN_full.sh
dbalarm.sh
dbdailychk.sh
schedule_rman_full_bkp.sh
active_sessions.sh
sql_id_details.sh
SQLPLUS became more friendly for DBAs if been invoked using “sql” alias:
– Fundamental info about the DB you’re connecting to.
– You current session details (OSPID, SID, SERIAL#).
– The prompt will be tagged with time, instance_name you’re connecting to and the connected user.
This will help you track your session log accurately plus minimize human mistakes by showing you the instance_name you’re connected to all the time.
– The format of common columns in DBA_* & V$ views will be well fitted in your display.
To download and for more details please visit this link:
http://dba-tips.blogspot.com/2014/02/oracle-database-administration-scripts.html