| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 9i RAC
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
"Remember amateurs built the ark - Professionals built the Titanic"
-- 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
 |
 |