Re: How to find out those parameters set in session leve

From: chuan <chuan.zhang_at_transact.com.au>
Date: 23 Sep 2002 22:22:53 -0700
Message-ID: <3c2dcaa0.0209232122.2175dda8@posting.google.com>

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3D8F39D6.FBE95CC5_at_exesolutions.com>...
> chuan wrote:
>
> > Hi, All,
> >
> > Is there any way to find out the parameters setting in session
> > level? These parameters are not the initialization parameters.
> > For example, if alter session set use_stored_outlines=true; how could
> > I find out the use_stored_outlines value later on?
> >
> > TIA
>
> SELECT name, value
> FROM v$parameter;
>
> Daniel Morgan

Hi, Daniel,

Thanks for the input. But "select name, value from v$parameter" can only get information about initialization parameters. You cannot get the value for,e.g,use_stored_outlines.
Any clues on this?
TIA Received on Tue Sep 24 2002 - 00:22:53 CDT