Re: OCP Tuning Sample Question

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 25 Jan 2000 15:31:23 GMT
Message-ID: <86kfkb$m8$2@news.seed.net.tw>

Buck Turgidson <jcmanNOSPAM_at_worldnet.att.net> wrote in message news:86fia3$m2n$1_at_bgtnsc03.worldnet.att.net...
> I now see the doc says OPTIMIZER_MODE at the instance level, and
> OPTIMIZER_GOAL at the session level. But OPTIMIZER_MODE seems to work at
> the session level. As long as I know how to answer the question.....

In precisely, in Oracle7, to specifies the approach of the optimizer, it's ALTER SESSION SET OPTIMIZER_GOAL,
in Oracle8, it's ALTER SESSION SET OPTIMIZER_MODE, OPTIMIZER_GOAL is still available but not documented. Received on Tue Jan 25 2000 - 09:31:23 CST