Resource Manager bug in 9.2.0.4?

From: Thomas Jeff <jeff.thomas_at_thomson.net>
Date: Thu, 25 Mar 2004 08:47:00 -0500
Message-ID: <358728A276824E419580403633AABFD001B7BA59@INDYSMAIL03.am.thmulti.com>

Wondering if anyone has experienced the following bug in Res Mgr (we are running 9.2.0.4 on AIX 4.3.3). We have a TAR in for this, but our experience is that tech support is completely hapless when it comes to Res Mgr issues.

The error occurs when we switch plans while users have ongoing uncommitted
transactions, their session will terminate with an ORA-600: internal error code, arguments: [kgskdecrstat1] when they issue a COMMIT. We had planned on implementing Res Mgr in our prod databases for various

reasons, with a need to switch plans, so this is a big show-stopper.

I can recreate the error in every database with something like the following:

SQL> create table xyz as select * from dba_objects where 1=2;

Table created.

SQL> insert into xyz select * from dba_objects where owner = 'SYS';

12561 rows created.

SQL> alter system set resource_manager_plan = '';

System altered.

SQL> alter system set resource_manager_plan = 'ES_RM_PLAN';

System altered.

SQL> commit;
commit
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error

Jeffery D Thomas
DBA
Thomson Information Services
Thomson, Inc.

Email: jeff.thomas_at_thomson.net

Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Thu Mar 25 2004 - 07:43:33 CST