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!

V$sql

happy10319May 7 2012 — edited May 9 2012
Hi,
on 11g R2,
when you restart database does v$sql loose /update the information ?

If yes that's why I do not find my query :

select sql_text from v$sql when sql_id ='jhyt9urt';
no row selected.

Ok then , in which permanent table can I find it ?
Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2012
Added on May 7 2012
9 comments
339 views