Is there a query I can run to determine what optimizer one of our databases in running. thanks
Printable View
Is there a query I can run to determine what optimizer one of our databases in running. thanks
sho parameter optimizer_mode
that did not work for me.
show
it works if you are using 8i otherwise look v$parameter
thanks