Re: show session parameter

eliot06 wrote:
> Hello,
>
> I wish to know how to make to post the parameters of a session.
> Typically I wish to know the value of the parameter
> "optimizer_featuree_enable", to use it running.
>
> thank you
>

The V$PARAMETER view can show the parameter values for your session.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2012.htm#sthref3816

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com