Database Blog
Showing posts with label
Oracle Performace Scripts
.
Show all posts
Showing posts with label
Oracle Performace Scripts
.
Show all posts
Thursday, 25 September 2014
What Wait Events Are Sessions Waiting On
›
Script shows what wait events are sessions waiting on : set linesize 120 col username format a10 col event format a30 select sid,...
List status of all submitted DBMS jobs
›
Lists status of all submitted DBMS jobs: set pagesize 100 set linesize 120 ttitle - center 'Submitted DBMS Jobs' skip 2 ...
Segments with highest I/O activity
›
This script will list the top 10 segments in the database that have the most number of physical reads against them. Script can also ...
Top SQL (Buffer Gets)
›
This script will list the top 5 SQL statements sorted by the most number of buffer gets or logical reads set serverout on size 100000...
Top SQL (Physical Reads)
›
This script will list the top 5 SQL statements sorted by the most number of physical reads set serverout on size 1000000 set fee...
›
Home
View web version