Re: HOw to know which optimiser server using

From: Pei L. Ku <pku_at_gte.net>
Date: 1998/01/19
Message-ID: <69ustp$ms7$4@gte2.gte.net>#1/1

Query the v$parameter view (which, by default, is visible to sys and system users). All the init.ora parameters (default or otherwise) are shown in that view. I believe the parameter associated to the optimizer mode is 'optimizer_mode'.

Pei

Sateesh Burgadda <sburgadd_at_evolving.com> wrote in article <34BFA846.2092_at_evolving.com>...
> hi!
>
> I would like to know which optimiser( cost based or rule based)
> is used on my server.
>
> I tried to see init.ora file but nothing found.
>
> Can u help me to know how.
>
>
> PL reply
> Sateesh
>
Received on Mon Jan 19 1998 - 00:00:00 CST