Oracle Database Administration Blog » V$SESSION

Posts tagged: V$SESSION

May 24 2010

Query to display blocked session and their blocking session details in Oracle 10g

SELECT sid, serial#, blocking_session_status, blocking_session
FROM v$session
WHERE blocking_session IS NOT NULL;

Database Administration | aarthimudhalvan | Comments (0)

blocking session details in Oracle 10g, Query to display blocked session and their blocking session details in Oracle 10g, V$SESSION

Sep 23 2009

Most important Tables to Scan Locks and activity

1. V$LOCK
2. V$LOCKED_OBJECT
3. V$SESSION
4. V$ACCESS
5. V$TRANSACTION

Database Administration, Database Maintenance | mudhalvan | Comments (0)

V$ACCESS, V$LOCK, V$LOCKED_OBJECT, V$SESSION, V$TRANSACTION

Alibi3col theme by Themocracy