Re: show session parameter

On Aug 27, 9:38 am, Brian Peasland <d..._at_nospam.peasland.net> wrote:
> 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/dynvie...
>
> HTH,
> Brian
>
> --
> ===================================================================
>
> Brian Peasland
> d...@nospam.peasland.nethttp://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 fromhttp://www.teranews.com

Yet he can't get to that view as he has no privileges on it as 'scott' as evidenced by the error message:

ORA-00942: Table ou vue inexistante

which translates to 'Table or view does not exist'. To use it he'll need either 'grant select on V_$PARAMETER to scott;' or grant scott the SELECT_CATALOG_ROLE.

David Fitzjarrell Received on Tue Aug 28 2007 - 10:26:11 CDT