Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Automatically altering session

Automatically altering session

From: Jill <jc_va_at_hotmail.com>
Date: Thu, 26 Aug 1999 06:51:12 -0700
Message-ID: <7q367e$b20$1@bgtnsc01.worldnet.att.net> 





We run PeopleSoft on an AIX server using 7.3.4.3.  Our on-line systems runs
well in CBO, but the batch COBOL on the server runs better in RBO.  Does
anyone know of a way that AIX can detect a batch process initiating, and
issue an "ALTER SESSION SET OPTIMIZER_GOAL = RULE"?  We would then leave the
database in a default mode of CHOOSE.



Thanks for your help.


Received on Thu Aug 26 1999 - 08:51:12 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US