Re: Resource Manager bug in 9.2.0.4?
- From: Tim Gorman <tim@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Mar 2004 07:27:09 -0700
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@xxxxxxxxxxx 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@xxxxxxxxxxx
>
> Indy DBA Master Documentation available at:
> http://gkmqp.tce.com/tis_dba <http://gkmqp.tce.com/tis_dba>
> --------------------------------------------
>
>
Other related posts:
