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: 9i RAC

RE: 9i RAC

From: <Govind.Arumugam_at_alltel.com>
Date: Tue, 29 Oct 2002 11:09:51 -0800
Message-ID: <F001.004F6B01.20021029110951@fatcity.com>


Look for the code
TOP 10 WRITE PINGING OBJECTS
TOP 10 READ PINGING OBJECTS and
TOP 10 FALSE PINGING OBJECTS
in opsdiag.sql ( available in metalink doc. id 205809.1 )

Last week, we wrote a shell script to gather the above information every 20 minutes ( instead of running opsdiag.sql every 20 minutes ) and started taking actions on the indexes where we were seeing a high level of waits caused by 'global cache cr request'.

Atleast two of the TOP 10 were indexes that could be comfortably dropped w/o causing any application degradation in our case.

Hope this helps.

Govind

-----Original Message-----
Sent: Tuesday, October 29, 2002 1:40 PM
To: Multiple recipients of list ORACLE-L

We are currently running 8i OPS and having serious issues with "global cache
request" waits that kill the performance on the machines. Because of this
issue, we are almost being forced to upgrade to 9i RAC.

I hope and pray that this will work out, but I've learned to not count on
much until you actually see it running in your environment.

I'm not concerned though because the sales people tell me it's the best thing since sliced bread. :)

Rick Stephenson
Oracle Database Administrator
Ovid Technologies, Inc.
rick_stephenson_at_ovid.com

-----Original Message-----
Sent: Tuesday, October 29, 2002 10:49 AM To: Multiple recipients of list ORACLE-L

I run it at home on the laptop if that counts :-)

But seriously, I'm working with a client who are migrating from a large Sun box to a 4node Tru64 RAC architecture on 9.2

Do I think it will work....probably not

Cheers
Connor


Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net

"Remember amateurs built the ark - Professionals built the Titanic"



Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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: Rick Stephenson
  INET: RStephenson_at_Ovid.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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: 
  INET: Govind.Arumugam_at_alltel.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Tue Oct 29 2002 - 13:09:51 CST

Original text of this message

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