RE: Changing from cost to rule bae optimization on the fly
- From: "Kennedy, Jim" <jim_kennedy@xxxxxxxxxx>
- To: <DGoodson@xxxxxxxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 21 Oct 2005 10:00:12 -0700
alter session set optimizer_mode=rule
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
Other related posts:
