Re: Resource Manager bug in 9.2.0.4?

From: Tim Gorman <tim_at_sagelogix.com>
Date: Thu, 25 Mar 2004 07:27:09 -0700
Message-ID: <BC883A4D.1218C%tim@sagelogix.com>

Jeff,

Wouldn¹t it make more sense to complete the transaction before using ALTER SYSTEM? Does the error reproduce when you do that?

-Tim

on 3/25/04 6:47 AM, Thomas Jeff at jeff.thomas_at_thomson.net wrote:

> 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 <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 - 08:25:13 CST