Skip to Main Content
Forums

SQL & PL/SQL

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 get the sql id and sql text for the pid which is completed.

user9354175Nov 8 2010 — edited Nov 8 2010
Hi All,

I like to know how the get the details of sql_id and sql_text using the proecess which is completed already (ie., no more showing in the top command).

But I have the details of the process id.

Database name: 11g
os: sun os

thanks

Edited by: user9354175 on Nov 8, 2010 10:42 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 6 2010
Added on Nov 8 2010
3 comments
1,687 views