From Concurrent Request ID
select SID,SERIAL# from gv$session
where audsid in (
select oracle_session_id
from apps.fnd_concurrent_requests
where request_id = &conc_req_number);
From PID:
select * from v$session where paddr in (select addr from v$process where spid = 7590);
select SID,SERIAL# from gv$session
where audsid in (
select oracle_session_id
from apps.fnd_concurrent_requests
where request_id = &conc_req_number);
From PID:
select * from v$session where paddr in (select addr from v$process where spid = 7590);
HI...
ReplyDeleteIs there any query to find the changes in a table database day by day ?
Thanks
ismath
you have got to query the audit tables
DeleteTry to search on oracle audit tables
Great, I wanted to check SID from PID and finally get it.
ReplyDelete