Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find the contents of proc from top command

577293Feb 11 2009 — edited Feb 11 2009
I had a doubt related to how to find the contents of a procedure or the statements from the PID displayed in top command if it can be done from TOAD or sqlplus. If we can find out the details from top like:-

--------------------------------------------------------------------------------------
21211 oracle 16 0 3228 1012 764 R 0 0.0 0:07.68 top
1 root 16 0 1732 552 472 S 0 0.0 0:01.29 init
--------------------------------------------------------------------------------------

say, what is the process with PID 21211 and 1 are doing?

I hope, my question is clear.

Please, help in solving the doubt.

regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2009
Added on Feb 11 2009
10 comments
583 views