In article <38902B25.4E19C394_at_0800-einwahl.de>,
Martin.Haltmayer_at_0800-einwahl.de wrote:
> And here again we are at the question: "Who certifies the certifiers?"
>
> Martin
>
> fumi wrote:
> >
> > Buck Turgidson <jcmanNOSPAM_at_worldnet.att.net> wrote in message
> > news:86f6d7$7f0$1_at_bgtnsc03.worldnet.att.net...
> > > This seems ambiguous to me. I think both C and D are correct, but
the
> > > question indicates only D. Am I missing something?
> > >
> > > "At which level is the optimizer mode set if you use the
OPTIMIZER_MODE
> > > parameter?
> > > A-Data
> > > B-System
> > > C-Session
> > > D-instance
> > > E-Statement.
> >
> > IMO, I think this question is nonsense.
> >
> > Where did you see this question?
> > In the Oracle Assessment Test, it's a multi-selection question.
> > The "answer(?)" is C and D.
> >
> > But (B), (D) are ambiguous, somebodies say "instance parameters",
> > somebodies say "system parameters".
> > Note there are two views called v$parameter, and v$system_parameter.
> >
> > Another tangle is the word "parameter", we don't say "session
parameter",
> > so somebodies may think C is not correct.
>
>
optimizer_mode is an INIT.ORA parameter - it therefore affects the
instance started with that INIT.ORA and all sessions running against
that instance that do not override the setting. "Alter session set
optimizer_goal ..." is session level - one can therefore override the
instance level optimizer_mode in one's session. Yet another way is to
include hints in statements submitted in one's session. This overrides
both optimizer_mode and optimizer_goal.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Jan 27 2000 - 20:22:27 CST
