To check os processid of oracle session , we can check v$process view.

SPID column of v$process view shows os processid.

We can use following query to check processid, status for specific user.

I have connected through sys user :

Now checking processid using above script.

check this processid 14399 from os prompt.


About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.