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

From: Nick <nick_hobbs_at_hotmail.com>
Date: 24 Sep 2002 04:32:38 -0700
Message-ID: <8ca3c5c7.0209240332.4d09c4e2@posting.google.com>

The V$PARAMETER table has the column ISMODIFIED. If the columns is set to "MODIFIED" the VALUE column will show the parameter has been changed using ALTER SESSION. If the columns is set to "SYS_MODIFIED" the change has been made by an ALTER SYSTEM command.

HTH Nick

All corrections welcomed.

> > > 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
> > >
Received on Tue Sep 24 2002 - 06:32:38 CDT