How to find out Optimizer's current Goal? ****
From: badri <badri_at_cc.gatech.edu>
Date: 1995/11/04
Message-ID: <47f8a5$fhn_at_gaia.cc.gatech.edu>#1/1
Date: 1995/11/04
Message-ID: <47f8a5$fhn_at_gaia.cc.gatech.edu>#1/1
Hi:
I am familiar with switching the optimizer's goal with an explicit hint, but how to find out it's current goal?
I tried "show all" and nothing about optimization came up. I am not sys in my system, so I could not see the v$ tables if they do contain the information.
Please help,
-Badri Received on Sat Nov 04 1995 - 00:00:00 CET