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> > -------------------------------------------- > >