Re: tracking down hidden SQL???

From: Adric Norris <>
Date: Wed, 16 Oct 2013 14:15:28 -0500
Message-ID: <>

On Wed, Oct 16, 2013 at 2:05 PM, Chris Taylor <> 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!

Received on Wed Oct 16 2013 - 21:15:28 CEST

Original text of this message