| Tuesday, May 19, 2009 |
| Lists all locked objects for whole RAC |
Hello Everyone!!!
Lists all locked objects for whole RAC.
-- ---------------------------------------------------------------------------------
SET LINESIZE 500
SET PAGESIZE 1000
SET VERIFY OFF
COLUMN owner FORMAT A20
COLUMN username FORMAT A20
COLUMN object_owner FORMAT A20
COLUMN object_name FORMAT A30
COLUMN locked_mode FORMAT A15
SELECT b.inst_id,
b.session_id AS sid,
NVL(b.oracle_username, '(oracle)') AS username,
a.owner AS object_owner,
a.object_name,
Decode(b.locked_mode, 0, 'None',
1, 'Null (NULL)',
2, 'Row-S (SS)',
3, 'Row-X (SX)',
4, 'Share (S)',
5, 'S/Row-X (SSX)',
6, 'Exclusive (X)',
b.locked_mode) locked_mode,
b.os_user_name
FROM dba_objects a,
gv$locked_object b
WHERE a.object_id = b.object_id
ORDER BY 1, 2, 3, 4;
SET PAGESIZE 14
SET VERIFY ON
-- ----------------------------------------------------------------------------------
Happy Learning,
--SreeneLabels: Lists all locked objects for whole RAC |
posted by Srinivasan .R @ 2:01 AM  |
|
| 2 Comments: |
-
Thank you taking time to provide us with your valuable post. We strive provide our students with excellent care & we taking your comment to heart.As alway, we appreciate your confidences and trusted.
iOS Training in Chennai
-
Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care.
CCNA Training in Chennai
|
| |
| << Home |
| |
|
|
Thank you taking time to provide us with your valuable post. We strive provide our students with excellent care & we taking your comment to heart.As alway, we appreciate your confidences and trusted.
iOS Training in Chennai