PeopleSoft Developers will showcase the knowledge and experience required to help developers tweak and program development and configuration of PeopleSoft engines
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;
PeopleSoft Developers
121 members
Description
PeopleSoft Developers will showcase the knowledge and experience required to help developers tweak and program development and configuration of PeopleSoft engines
Identify Locked object in Oracle Database
by Darryl Daley
Aug 28, 2013
Identify Locked object in Oracle Database:
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$session where sid=591;