These kind of information may be installed in the fixed tables,like all the
default initialization parameters values are stored there.
But usually you don't need to find out these things by tables, they are all
documented.
"chuan" <chuan.zhang_at_transact.com.au> wrote in message
news:3c2dcaa0.0209232122.2175dda8_at_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 - 01:22:40 CDT
