In this Blog you can learn Oracle 11g, 10g, 9i Database Administration and Oracle Developer Suit 6i, 10g, 11g Forms, reports Software Development.
Monday, 29 August 2016
How to Kill Locked Objects and Session Oracle 11g Database
select * from v$locked_object
1- SELECT sid FROM v$lock WHERE id1=51891
2- SELECT sid, serial# from v$session where sid=155
3- ALTER SYSTEM KILL SESSION '155,1098' ;
Step-1
SELECT object_id FROM dba_objects WHERE object_name='EMP';
OBJECT_ID
----------
7401242
Step-2
If there are no locks present for the table ‘EMP’ this query won’t return any values.
SELECT sid FROM v$lock WHERE id1=7401242
SID
----------
3434
Step-3
SELECT sid, serial# from v$session where sid=3434
SID SERIAL#
---------- ----------
3434 92193
Step-4
ALTER SYSTEM KILL SESSION '3434,92193' ;*/
Performance Tuning Interview Questions and Answers
performance tuning questions and solutions 1. A tablespace has a table with 30 extents in it. Is this bad? Why or why not? Expected answ...
-
1) How can you see the Current SCN number of the database? > Select current_scn from v$database; 2) How can you see the Current log...
-
Oracle DBA Interview Questions/FAQs Part1 1. What is an instance? SGA + background processes. 2. What is SGA? System/Shared Global Ar...
-
SQL> insert into myobjects select * from myobjects; 919664 rows created. SQL> commit; Commit complete. SQL> sele...