Table lock identification in Database

We will face very regularly, Table lock issue which will cause the Application engines and SQR processes to error.

Here is the sql to find out the locked tables in Database.

select
c.owner,
c.object_name,
c.object_type,
b.sid,
b.serial#,
b.status,
b.osuser,
b.machine,
b.program,
b.type,
b.client_info
from
v$locked_object a ,
v$session b,
dba_objects c
where
b.sid = a.session_id
and
a.object_id = c.object_id;

Once we identified the table is locked we can request DBA team to release the table.

Intrested in PeopleSoft Learning Please reach us on  info@OnlineIT365.com 
OnlineIT365.com.
www.facebook.com/ONLINEIT365
twitter.com/ONLINEIT365