From oracle-l-bounce@freelists.org Thu Mar 25 10:23:32 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2PGNUa17129 for ; Thu, 25 Mar 2004 10:23:31 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2PGNIo17064 for ; Thu, 25 Mar 2004 10:23:19 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 142C939241A; Thu, 25 Mar 2004 11:18:41 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01940-92; Thu, 25 Mar 2004 11:18:40 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D468F392D67; Thu, 25 Mar 2004 11:16:00 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 25 Mar 2004 11:14:39 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8E2E6390911 for ; Thu, 25 Mar 2004 11:08:14 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00574-22 for ; Thu, 25 Mar 2004 11:08:14 -0500 (EST) Received: from tera.umi.com (tera.umi.com [192.195.245.144]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A996E39197B for ; Thu, 25 Mar 2004 11:02:43 -0500 (EST) Received: from bosmail02.bos.il.pqe (bosmail02.bos.il.pqe [172.24.3.66]) by tera.umi.com (8.11.6/8.11.6) with ESMTP id i2PGA0905738 for ; Thu, 25 Mar 2004 11:10:00 -0500 Received: from bosmail00.bos.il.pqe ([172.24.3.64]) by bosmail02.bos.il.pqe with Microsoft SMTPSVC(5.0.2195.6713); Thu, 25 Mar 2004 11:10:01 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C41283.A06EF11C" Subject: RE: Resource Manager bug in 9.2.0.4? Date: Thu, 25 Mar 2004 11:10:01 -0500 Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF03B453B7@bosmail00.bos.il.pqe> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Resource Manager bug in 9.2.0.4? Thread-Index: AcQSg36PrrB6RNceTQaD2O/Dv3UgFQAABlPQ From: "Bobak, Mark" To: X-OriginalArrivalTime: 25 Mar 2004 16:10:01.0726 (UTC) FILETIME=[A09399E0:01C41283] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1782 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mark.Bobak@il.proquest.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org ------_=_NextPart_001_01C41283.A06EF11C Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Not to mention, ORA-00600 is, by definition, a bug. -----Original Message----- From: John Hallas [mailto:john.hallas@hcresources.co.uk] Sent: Thursday, March 25, 2004 10:38 AM To: oracle-l@freelists.org Subject: RE: Resource Manager bug in 9.2.0.4? 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=20 John =20 -----Original Message----- From: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org] On Behalf Of Tim Gorman Sent: 25 March 2004 14:27 To: oracle-l@freelists.org Subject: Re: Resource Manager bug in 9.2.0.4? =20 Jeff, Wouldn=92t 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@thomson.net wrote: Wondering if anyone has experienced the following bug in Res Mgr (we=20 are running 9.2.0.4 on AIX 4.3.3). We have a TAR in for this, but=20 our experience is that tech support is completely hapless when it=20 comes to Res Mgr issues.=20 The error occurs when we switch plans while users have ongoing = uncommitted=20 transactions, their session will terminate with an ORA-600: internal=20 error code, arguments: [kgskdecrstat1] when they issue a COMMIT. =20 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.=20 I can recreate the error in every database with something like the=20 following:=20 SQL> create table xyz as select * from dba_objects where 1=3D2;=20 Table created.=20 SQL> insert into xyz select * from dba_objects where owner =3D 'SYS';=20 12561 rows created.=20 SQL> alter system set resource_manager_plan =3D '';=20 System altered.=20 SQL> alter system set resource_manager_plan =3D 'ES_RM_PLAN';=20 System altered.=20 SQL> commit;=20 commit=20 *=20 ERROR at line 1:=20 ORA-00603: ORACLE server session terminated by fatal error=20 =20 --------------------------------------------=20 Jeffery D Thomas=20 DBA=20 Thomson Information Services=20 Thomson, Inc.=20 Email: jeff.thomas@thomson.net=20 Indy DBA Master Documentation available at:=20 http://gkmqp.tce.com/tis_dba = =20 --------------------------------------------=20 =20 --- 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 ------_=_NextPart_001_01C41283.A06EF11C Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Re: Resource Manager bug in 9.2.0.4?
Not to=20 mention, ORA-00600 is, by definition, a bug.
-----Original Message-----
From: John Hallas=20 [mailto:john.hallas@hcresources.co.uk]
Sent: Thursday, March = 25,=20 2004 10:38 AM
To: oracle-l@freelists.org
Subject: = RE:=20 Resource Manager bug in 9.2.0.4?

Fair point = Tim, but=20 it should not be the case that you need a quiescent system before = changing=20 plans.

On many = systems that=20 situation is almost impossible to achieve =

John

 

-----Original=20 Message-----
From:=20 oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Tim = Gorman
Sent: 25 March 2004 = 14:27
To: = oracle-l@freelists.org
Subject: Re: Resource Manager = bug in=20 9.2.0.4?

 

Jeff,

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

-Tim

on 3/25/04 6:47 = AM,=20 Thomas Jeff at jeff.thomas@thomson.net = wrote:

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

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

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


SQL> create = table xyz as=20 select * from dba_objects where 1=3D2;=20

Table=20 created. =

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

12561 rows=20 created. =

SQL> alter = system set=20 resource_manager_plan =3D ''; =

System=20 altered. =

SQL> alter = system set=20 resource_manager_plan =3D 'ES_RM_PLAN';=20

System=20 altered. =

SQL>=20 commit;
commit=20
*=20
ERROR at line=20 1:
ORA-00603: ORACLE = server=20 session terminated by fatal error
           &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;          
<= /FONT>
--------------------------------------------=20
Jeffery D=20 Thomas
DBA=20
Thomson = Information=20 Services
Thomson,=20 Inc. =

Email:=20 jeff.thomas@thomson.net =

Indy DBA Master=20 Documentation available at: =
http://gkmqp.tce.com/tis_dba <http://gkmqp.tce.com/tis_dba>= ;=20
--------------------------------------------

 


---
Incoming mail is certified Virus = Free.
Checked by=20 AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.581 / = Virus=20 Database: 368 - Release Date: 09/02/2004


---
Outgoing mail is certified Virus = Free.
Checked by=20 AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.581 / = Virus=20 Database: 368 - Release Date:=20 09/02/2004

------_=_NextPart_001_01C41283.A06EF11C-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------