Re: [Q] How to check session Optimizer_mode ..

Nope... does not work in SQL*PLUS or in Server Manager....  Does anyone else have any other suggestions? Any DD view to query from to find out this information?

Thanks,
--Vikas

On 14 Nov 1996 05:32:05 GMT, Murali Kazhipurath <murali_at_jps.net> wrote:
>Try SHOW OPTIMIZER. I don't think this works from SQL*Plus. You may want to
>try this command from the Service Manager.
>
>Murali
>--
>Murali Kazhipurath
>Technical Consultant
>Kaustubam (Database and Internet Solutions Provider)
>murali_at_jps.net
>Phone # (916) 773 1918
>
>MCC <duffy_at_cais.cais.com> wrote in article <56a9q3$dlg_at_news2.cais.com>...
>> we have SUN Sparc solaris 2.5 with Oracle 7.2.3 installed on it. I
 wonder
>> is there has a way to check what is my session "optimizer_goal " mode.
 If
>> I use "alter session set optimizer_goal= rule", how can I confirm that
>> change?
>>
>>
>> Thank you for help.
>>
  Received on Thu Nov 14 1996 - 00:00:00 CET