Re: optimizer mode - how to tell

You could do a:
SELECT *
  FROM v$parameter
 WHERE name LIKE '%optimizer%';

or in svrmgrl, do a:
SHOW PARAMETERS OPTIMIZER HTH,
Verna

<kal121_at_yahoo.com> wrote in message news:7unfrc$9e1$1_at_nnrp1.deja.com...
> Version: Oracle 805 for Solaris
>
> Aside from the init.ora file, where can I find out what optimizer mode
> I'm presently using? On WinNT, I believe you could query the v$parameter
> view and look at the value for "optimizer_mode" or something like that.
> I don't see this on Solaris - in fact, it doesn't seem to show a lot of
> the parameters I'm used to seeing in this view. Am I just imagining
> this?
>
> Thx
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Oct 21 1999 - 13:43:13 CDT