Job Seekers   Employers
dbapool: Authors | Submissions | Contact Us
   Forgot password? | Sign up
  Home   Discussion Forum   Articles   Interview Questions   FAQs   Scripts   Rewards   Analyzer   White Papers   Blog   Certification   Downloads   Tools
 


Frequently Asked Questions

Go Back to FAQ list


How do you find out the unix process id of a database session?
By:- Viswanath Sarma
 11 Person(s) found this faq useful.


Some times you might want to get the unix process details of a database session. You have the Oracle session details. Just map them with paddr column from v$process ! You're done.

e.g.

SQL> select p.spid from v$session s, v$process p where s.sid=16 and s.paddr=p.addr

SPID
---------
16750


Did you find this FAQ helpful?

Yes: No:

Name:

Email:

Comments:




Go Back to FAQ list






  About Us Advertise Terms of Use Privacy Newsletters Contact Us    

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads 

Our Premium Sponsor
Confio Software