On 27 août, 15:12, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Aug 27, 8:09 am, eliot06 <p.hi..._at_gmail.com> wrote:
>
>
>
> > 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 ?
>
> You COULD grant SELECT_CATALOG_ROLE to this 'simple user', but why
> would a 'simple user' need access to such tables/views?
>
> David Fitzjarrell
to eeing what optimizer is used ? whit the session scott.
Received on Mon Aug 27 2007 - 08:38:21 CDT
