Re: HOw to know which optimiser server using

Sateesh Burgadda wrote:
>
> 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

Select the value from v$parameter

Vijay Darekar Received on Fri Jan 16 1998 - 00:00:00 CST