Re: Automatically altering session

From: Karen Abgarian <karen.abgarian_at_fmr.com>
Date: Thu, 26 Aug 1999 14:05:28 -0400
Message-ID: <37C581E8.31A2F6B9@fmr.com>

Hi Jill

I'm afraid there's no robust way to do it from inside the database. Somebody mentioned
ON-LOGON database triggers, but they are not available in O7.

The nicest place to put this ALTER SESSION statement is the beginning of your job's
code. Perhaps you can find a way to put it there.

Rgrds,
Karen Abgarian.

Jill wrote:

> 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 - 13:05:28 CDT