Re: show session parameter

From: eliot06 <p.hirth_at_gmail.com>
Date: Mon, 27 Aug 2007 13:09:02 -0000
Message-ID: <1188220142.206385.145810@r34g2000hsd.googlegroups.com>

On 27 août, 14:58, eliot06 <p.hi..._at_gmail.com> 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

SQL> conn sys as sysdba
Entrez le mot de passe :
Connecté.
SQL> show parameter optimizer

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
optimizer_dynamic_sampling           integer     2
optimizer_features_enable            string      10.2.0.3
optimizer_index_caching              integer     0
optimizer_index_cost_adj             integer     100
optimizer_mode                       string      ALL_ROWS
optimizer_secure_view_merging        boolean     TRUE

SQL> thath's ok !!

SQL> conn paie/passwd_at_uid
Connecté.
SQL> show parameter optimizer
ORA-00942: Table ou vue inexistante

user paie is a simple user, how can i do ? Received on Mon Aug 27 2007 - 08:09:02 CDT