This is just a test posting, cleverly disguised as something better than the typical "test posting - delete". -- -- pct_wait.sql - Show the waits that have made the largest -- contribution to a session's lifetime. -- column username format a20; column event format a40; column elapsed format 99999999; column total_waits format 99999999; column pct format 999.999; break on sid skip 1 on sid; SELECT s.sid, s.username, se.event, (sysdate-s.logon_time)*60*60*24 elapsed, se.total_waits, se.total_timeouts, se.average_wait/100 average_wait, se.max_wait/100 max_wait, se.time_waited/100 time_waited, se.time_waited/((sysdate-s.logon_time)*60*60*24) pct FROM v$session s, v$session_event se WHERE s.sid = se.sid AND s.logon_time != sysdate AND se.time_waited > 0 AND se.event NOT IN ( 'wait for unread message on broadcast channel', 'pipe get', 'queue messages', 'PL/SQL lock timer', 'unread message', 'pmon timer', 'rdbms ipc message', 'smon timer', 'wakeup time manager') ORDER BY s.sid, pct desc; ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------