Re: Session level parameter
From: Mark Malakanov <markmal_at_delete-this-antispammer.home.com>
Date: Tue, 24 Apr 2001 14:03:00 GMT
Message-ID: <oIfF6.44372$_P.12412498_at_news3.rdc1.on.home.com>
Date: Tue, 24 Apr 2001 14:03:00 GMT
Message-ID: <oIfF6.44372$_P.12412498_at_news3.rdc1.on.home.com>
Use optimizer_mode. You can set optimizer_goal, but you will see new value in optimizer_mode.
-- ----------------------------------------------------- Thanks, Mark "Lois" <lpfeng1_at_home.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:_S3F6.17386$Jh5.17735322_at_news1.rdc1.sfba.home.com...Received on Tue Apr 24 2001 - 16:03:00 CEST
> Hi,
>
> But this item does not exist in both the v$parameter and
v$system_parameter.
>
> lois
>
> "Mark Malakanov" <markmal_at_delete-this-antispammer.home.com> wrote in
message
> news:4J_E6.36049$_P.10126842_at_news3.rdc1.on.home.com...
> > select from v$parameter.
> > It is session level.
> >
> > --
> > -----------------------------------------------------
> > Thanks,
> > Mark
> >
> > "Lois" <lpfeng1_at_home.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
> > news:HYYE6.16743$Jh5.17260978_at_news1.rdc1.sfba.home.com...
> > > Hi,
> > >
> > > How can I find out the value of a session level parameter like
> > > optimizer_goal?
> > >
> > >
> >
> >
>
>