BrogainTechnology ( Oracle DBA Training)
Pages
Oracle Database Related Scripts
Oracle Database Scripts
About Brogain Technolgy
Oracle DBA Course Summary
Stand Database/Data Guard
Showing posts with label
How to identify the sid using Server Process id in oracle database
.
Show all posts
Showing posts with label
How to identify the sid using Server Process id in oracle database
.
Show all posts
Friday, January 13, 2012
How to identify the sid using Server Process id in oracle database
select
sid
from
v$session
where paddr in (select addr from v$process
where background is null
and
spid=&Server_process_id);
Older Posts
Home
Subscribe to:
Posts (Atom)