Re: tracking down hidden SQL???
From: Adric Norris <landstander668_at_gmail.com>
Date: Wed, 16 Oct 2013 14:15:28 -0500
Message-ID: <CAJueESq9XzWq7tBhWg2tycNvD=HUmPxkfra433O07PR5jqqV6Q_at_mail.gmail.com>
On Wed, Oct 16, 2013 at 2:05 PM, Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:
> Did you try querying [g]v$session PREV_SQL_ID as well for those sessions
> that are showing the SQL_ID you're interested in? (Kerry mentioned it in
> that blog post). The prev_sql_id might give you a clue about why this
> sql_id is showing up as the current one?
>
Date: Wed, 16 Oct 2013 14:15:28 -0500
Message-ID: <CAJueESq9XzWq7tBhWg2tycNvD=HUmPxkfra433O07PR5jqqV6Q_at_mail.gmail.com>
On Wed, Oct 16, 2013 at 2:05 PM, Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:
> Did you try querying [g]v$session PREV_SQL_ID as well for those sessions
> that are showing the SQL_ID you're interested in? (Kerry mentioned it in
> that blog post). The prev_sql_id might give you a clue about why this
> sql_id is showing up as the current one?
>
The previous PREV_SQL_ID is always identical, but is unfortunately just a connection pool session-test query.
select 2+2 from dual
I appreciate the suggestion!
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 16 2013 - 21:15:28 CEST