RE: Changing from cost to rule bae optimization on the fly

From: Kennedy, Jim <jim_kennedy_at_mentor.com>
Date: Fri, 21 Oct 2005 10:00:12 -0700
Message-ID: <EF25DB6D87DD1A469C80A312C63C3B4C04C5076A@SVR-ORW-EXC-07.mgc.mentorg.com>

alter session set optimizer_mode=rule

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Goodson, Doris Sent: Friday, October 21, 2005 9:56 AM
To: oracle-l
Subject: Changing from cost to rule bae optimization on the fly

Hi List,

I am running 9.2.0.2 Oracle on AIX 5.2. My online is acceptable, however COBOL batch is slow. Is there a way that I can switch from cost to rule base optimization for the session running the batch process without having to shut the system down?

Thanks,

Doris

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 21 2005 - 12:02:25 CDT