Re: I can't find the sql_text but sql_id is exist
From: coskan gundogar <coskan_at_gmail.com>
Date: Mon, 19 Dec 2011 08:25:03 +0000
Message-ID: <CAGLGTvNg-cCctBQNESwQ5jjWpcawn51EGY3BFtLkgJ6bwOvi+A_at_mail.gmail.com>
You may want to check below
http://kerryosborne.oracle-guy.com/2009/04/hidden-sql-why-cant-i-find-my-sql-text/
Date: Mon, 19 Dec 2011 08:25:03 +0000
Message-ID: <CAGLGTvNg-cCctBQNESwQ5jjWpcawn51EGY3BFtLkgJ6bwOvi+A_at_mail.gmail.com>
You may want to check below
http://kerryosborne.oracle-guy.com/2009/04/hidden-sql-why-cant-i-find-my-sql-text/
Sent from my mobile device
On Dec 19, 2011 7:50 AM, "louis" <ylouis83_at_gmail.com> wrote:
> 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
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 19 2011 - 02:25:03 CST