9 Replies Latest reply: May 9, 2012 6:10 AM by user522961 RSS

    V$sql

    user522961
      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.