| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> 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
Log into sql*plus and issue the following command.
select value from v$parameter
where name like '%mode%' ;
Received on Wed Jan 21 1998 - 00:00:00 CST
 |
 |