Re: How to find out parameter setting at session level?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 19 Sep 2002 16:37:51 +1000
Message-ID: <w6ei9.35678$g9.101619@newsfeeds.bigpond.com>

Hi Chuan

If you have sufficient privileges, try:

show parameter use_stored_outlines

Cheers

Richard
"chuan" <chuan.zhang_at_transact.com.au> wrote in message news:3c2dcaa0.0209181525.7072144b_at_posting.google.com...
> 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
>
> Chuan
Received on Thu Sep 19 2002 - 01:37:51 CDT