-- Description : Displays information on all database session waits. -- Requirements : Access to the V$ views. -- Call Syntax : @session_waits -- ----------------------------------------------------- SET LINESIZE 200 SET PAGESIZE 1000 COLUMN username FORMAT A20 COLUMN event FORMAT A30 COLUMN wait_class FORMAT A15 SELECT NVL(s.username, '(oracle)') AS username, s.sid, s.serial#, sw.event, sw.wait_class, sw.wait_time, sw.seconds_in_wait, sw.state FROM v$session_wait sw, v$session s WHERE s.sid = sw.sid ORDER BY sw.seconds_in_wait DESC;
Database Session Waits Scripts
Subscribe to:
Post Comments (Atom)
ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'
ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...
-
CONCURRENT MANAGER ISSUES IN APPS R12 Status code and Phase code for Concurrent requests Here is what the abbreviation for ...
-
How to clean FND_NODES table in R12.2.4 Step 1: Always apply the latest cloning patches to avoid all the bugs and fixes Step 2: ...
-
ora-00257: archiver error. connect as sysdba only until resolved. Error While Connecting db through SQL Developer... Cause The ...
No comments:
Post a Comment