Is there any way that we can change the optimizer_mode
for a running session ? [Oracle 8.1.7]
The session may have started with the instance-level
optimizer_mode=RULE [Oracle Apps R11.0] but I
want to change the optimizer_mode for subsequent SQLs
executed by the session, without killing and
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL alter session set optimizer_mode = rule;
Session altered.
SQL
SQL alter session set optimizer_mode = choose;
Session altered.
SQL
HTH
Mark
Oh, my bad.. ;)
Here you go:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL select sid, serial#, username from v$session;
SIDSERIAL# USERNAME
-- -- --
What makes you think that the optimizer_mode is set to anything from your
example...??
Regis
-Original Message-
Sent: Thursday, June 12, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L
Oh, my bad.. ;)
Here you go:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With
Thank you.
I had done a DESC DBMS_SYSTEM and used SET_EV but never bothered to look
for doc/notes on SET_BOOL_PARAM_IN_SESSION.
Hemant
At 04:08 AM 12-06-03 -0800, you wrote:
Oh, my bad.. ;)
Here you go:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
optimizer_mode for a running session
Oh, my bad.. ;)
Here you go:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL select sid, serial#, username from v$session;
SIDSERIAL# USERNAME