Re: OCP Tuning Sample Question

From: Dave Grzebien <dgrzebie_at_columbus.rr.com>
Date: Sun, 23 Jan 2000 16:35:23 GMT
Message-ID: <388B2EA5.7750B52B@columbus.rr.com>

The answer is D. The reason is that the OPTIMIZER_MODE parameter is used at the startup of an instance. Therefore, it is set at the instance level. It is true that this can be modified at the session, but that is done by the ALTER SESSION statement.

Dave Grzebien
Expert Technical Consultants, Inc

Buck Turgidson wrote:

> 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.
Received on Sun Jan 23 2000 - 10:35:23 CST