Re: tracking down hidden SQL???
- From: Adric Norris <landstander668@xxxxxxxxx>
- To: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
- Date: Wed, 16 Oct 2013 14:15:28 -0500
On Wed, Oct 16, 2013 at 2:05 PM, Chris Taylor <
christopherdtaylor1994@xxxxxxxxx> 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!
--
//www.freelists.org/webpage/oracle-l
Other related posts:
