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
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-lReceived on Mon Dec 19 2011 - 01:49:59 CST