RE: Resource Manager bug in 9.2.0.4?
- From: "John Hallas" <john.hallas@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Mar 2004 15:37:53 -0000
Fair point Tim, but it should not be the case that you need a quiescent
system before changing plans.
On many systems that situation is almost impossible to achieve
John
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tim Gorman
Sent: 25 March 2004 14:27
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Resource Manager bug in 9.2.0.4?
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:
HYPERLINK "http://gkmqp.tce.com/tis_dba"http://gkmqp.tce.com/tis_dba
HYPERLINK "http://gkmqp.tce.com/tis_dba";<http://gkmqp.tce.com/tis_dba>
--------------------------------------------
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.581 / Virus Database: 368 - Release Date: 09/02/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.581 / Virus Database: 368 - Release Date: 09/02/2004
Other related posts:
