RE: Resource Manager bug in 9.2.0.4?

From: Thomas Jeff <jeff.thomas_at_thomson.net>
Date: Thu, 25 Mar 2004 14:30:33 -0500
Message-ID: <358728A276824E419580403633AABFD0021F6104@INDYSMAIL03.am.thmulti.com>

OK, Tim's comments made me realized that I needed to do some more RFTMing.
If I simply switch to another plan, say, the default SYSTEM_PLAN, and then
back, it works; no errors.

	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org


[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tim Gorman

	Sent: Thursday, March 25, 2004 12:35 PM
	To: oracle-l_at_freelists.org
	Subject: Re: Resource Manager bug in 9.2.0.4?
	
	
	I'm not suggesting that the system be quiesced.  I'm just

suggesting that, for the session which issues the ALTER SYSTEM, commit or rollback any in-flight transactions first.         

        I don't feel that it's unreasonable for an in-flight transaction to fail when an ALTER SYSTEM is executed in its midst. Yes, an ORA-00600 is considered a bug, but chances are good that the "fix" will be to assign a valid Oracle error to the condition anyway...                           

        on 3/25/04 9:10 AM, Bobak, Mark at Mark.Bobak_at_il.proquest.com wrote:                  

                Not to mention, ORA-00600 is, by definition, a bug.                                          

			-----Original Message-----
			From: John Hallas


[mailto:john.hallas_at_hcresources.co.uk]

			Sent: Thursday, March 25,  2004 10:38 AM
			To: oracle-l_at_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                         

                        John                                                                           

			-----Original  Message-----
			From:  oracle-l-bounce_at_freelists.org


[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tim Gorman

			Sent: 25 March 2004 14:27
			To: oracle-l_at_freelists.org
			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_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> <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                                                                             

---

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 - 13:46:58 CST