I can't find the sql_text but sql_id is exist

From: louis <ylouis83_at_gmail.com>
Date: Mon, 19 Dec 2011 15:49:59 +0800
Message-ID: <CAARjh8=C-OaEF8xEZvszneXrPpFyP+cvvGSnqGDBCLGrneGMng_at_mail.gmail.com>



Hi: Everyone

      When I monitoring the system I found some sessions cause the wait_event --------- i/o slave wait in a few seconds

and I found the sql_id of these sessions is 38wm92jbxu0vf,but when I query v$sql I found the sql_text is null

who can explain these? and I guess this query is on a table with clob column.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 19 2011 - 01:49:59 CST

Original text of this message