Monday, April 18, 2016
Unlocking Oracle table
SELECT object_id FROM dba_objects WHERE object_name='MYHR_TBL';
| OBJECT_ID |
|---|
| 92169 |
Get Session ID
SELECT sid FROM v$lock WHERE id1=92169
| SID |
|---|
| 787 |
Get Serial
SELECT sid, serial# from v$session where sid=787
| SID | SERIAL# |
|---|---|
| 787 | 4273 |
Kill session and serial:
ALTER SYSTEM KILL SESSION '787,4273' ;
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment