One of the best sites for scripts related to checking library cache locks… http://allappsdba.blogspot.qa/2012/04/to-check-library-cache-lock-contention.html
Tag Scripts
COLUMN object_name FORMAT A40 COLUMN number_of_blocks FORMAT 999,999,999,999 SELECT o.object_name, COUNT(*) number_of_blocks FROM DBA_OBJECTS o, V$BH bh WHERE o.data_object_id =…
prompt ************************************ prompt **** ASH OVERALL WAIT PROFILE prompt ************************************ set lines 999 SELECT MIN(sample_time) min_ash_available,sysdate-MIN(sample_time) available duration FROM v$active_session_history;…
http://gavinsoorma.com/2012/11/ash-and-awr-performance-tuning-scripts/
Today on one of our 10g (10.2.0.1, don’t ask !) production databases running on AIX 5.3 we saw the following…
For running a single SQL Command via sqlplus on multiple servers, we have to first do a few pre-requisites 1.…
Even when sessions are inactive they can be executing SQL’s in the background. You have to identify the SQL’s which…
Sometimes on a system it is important to know the maximum user processes does not increase so much that it…
Here are some scripts related to Tables/Indexes . Tabs w/ Questionable Inds TABLES WITH QUESTIONABLE INDEX(ES) NOTES: Owner – Owner…
Many times it becomes necessary to append date stamp on your export dumps. In Unix systems, shell scripting is very…
A small shell script to check instance status of oracle database. $vi instanceup.sh #!/bin/sh SERVICE=’ora_pmon_orcl’ #replace ‘orcl’ with your sid…