Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Nasty bug in 9.2.0.1 (was: Oracle and Cache Hit Ratio based t

RE: Nasty bug in 9.2.0.1 (was: Oracle and Cache Hit Ratio based t

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Fri, 13 Sep 2002 07:28:23 -0800
Message-ID: <F001.004CF7D0.20020913072823@fatcity.com>


We have also complained (in writing) to our Sales Reps and have asked for a patch backported to 9.2.0.1 release. Since 9.2 is supposed to be the terminal release for 9i, and 10i (or whatever they call it) is at least a year away, we (and others as well) would like to have (and not just hope for) a bug free 9.2 environment. Now that COE is talking about OWI based tuning (Note # 283852), Oracle should fix this bug in 9.2.

-----Original Message-----
Sent: Friday, September 13, 2002 10:03 AM To: Multiple recipients of list ORACLE-L t

Good idea. We're having an Oracle rep coming to our company to talk up all the advantages of 9i and I certainly intend to raise this issue.  

Thank you Alexander for bringing it to our attention.  

Jay Miller

-----Original Message-----
Sent: Wednesday, September 11, 2002 1:34 PM To: Multiple recipients of list ORACLE-L train

You should call your sales persons and start applying pressure for them to provide a correction to 9ir2.
I am doing this right now.  

Yechiel Adar
Mehish

FWIW There is a document (id 283852) on Metalink updated on 03-SEP-2002 created by "CENTER OF EXPERTISE" named

THE COE PERFORMANCE METHOD
A PERFORMANCE METHODOLOGY FOR ENTERPRISE-WIDE INFORMATION SYSTEMS which shows that Oracle Corporation turned from "ratio" to "wait interface" approach.

The bad news is that in version 9.2.0.1 view V$SESSION_EVENT broken (bug 2429929), also described in Notes 208066.1. Bug fixed in 10i.

This bug affects OEM, BSTAT/ESTAT, STATSPACK, etc.

Did anybody adjust scripts which join V$SESSION with V$SESSION_EVENT? Should we use something like s.sid=e.sid+1 or s.sid-1=e.sid?

Alex.

-----Original Message-----
<mailto:Michael.Johnson_at_oln-afmc.af.mil> ]

Looks like Cache Hit Ratios may finally go away !!!

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Miller, Jay
  INET: JayMiller_at_TDWaterhouse.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Sep 13 2002 - 10:28:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US