Identify Locked object in Oracle Database:

select s.sid, s.serial#, p.spid,s.osuser, s.username,s.SQL_HASH_VALUE,s.status,s.machine,s.program,s.module,s.LOGON_TIME
from
   v$session s,
   v$process p
where
   s.paddr = p.addr
and
   s.sid in (select SESSION_ID from v$locked_object);
select * from v$sql where hash_value=4260304665;  
select * from v$session where sid=591; 

Views: 105

PeopleSoft Jobs in US

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service