Re: [Q] How to check session Optimizer_mode ..
From: Murali Kazhipurath <murali_at_jps.net>
Date: 1996/11/14
Message-ID: <01bbd03f$2fe870a0$65646464_at_licorice>#1/1
Date: 1996/11/14
Message-ID: <01bbd03f$2fe870a0$65646464_at_licorice>#1/1
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