On 27 août, 15:38, eliot06 <p.hi..._at_gmail.com> wrote:
> 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 seeing what optimizer is used ? whit the session scott.
thank's
Received on Mon Aug 27 2007 - 08:41:51 CDT
