Script – Top database wait events

This script will list the top 5 database wait events since instance startup sorted by time waited set linesize 120 col event format a30 select * from ( select event, total_waits, total_timeouts, time_waited from v$system_event where event not like ‘SQL*Net%’ and event not in (‘pmon timer’,’rdbms ipc message’,’dispatcher timer’,’smon timer’) order by time_waited desc ) […]

Identify 'hot' objects when faced with 'Cache Buffers Chains Latch' wait event

select count(*) child_count, sum(gets) sum_gets, sum(misses) sum_misses, sum(sleeps) sum_sleeps from v$latch_children where name = ‘cache buffers chains’; select p1 “File #”. p2 “Block #” from v$session_wait where event =’cache buffer chains’; select owner, segment_name, segment_type from dba_extents where file_id = &P1 and &P2 between block_id and block_id + blocks -1; col object_name format a20 col […]

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?