Re: Top SQL question

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 19 May 2005 21:09:28 -0700
Message-ID: <1116562168.262785.194880@g14g2000cwa.googlegroups.com>

Chuck wrote:
> Aren't they both 10g features? I'm on 9i (see OP).

DBMS_XPLAN is available in 9ir2, AFAIK. At least, I'm using it...

> All I can figure is
> that somewhere the application is issuing an alter session and
changing
> something that affects the execution plan. Is there a view I can
query
> to see the parameters in effect for a particular session other than
my own?

In 9i, not that I know of. Received on Thu May 19 2005 - 23:09:28 CDT