Say what ?
"xueyang" <xueyangy_at_singnet.com.sg> wrote in message
news:amovuf$no2$1_at_reader01.singnet.com.sg...
> 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 - 08:06:16 CDT
