John, I double checked it and both instances were lower than the initial readings.
One thing I have found out since my initial question is that the v$bh table that Michael had referred to is based on sga db buffers. So there is the possibility of something that could of had a lot of pinging but was aged out of the dba buffers, this could reduce the numbers in the v$ping table. Bryan -----Original Message----- Sent: Wednesday, May 29, 2002 6:21 PM To: Multiple recipients of list ORACLE-L Are you sure you are comparing the v$ping table from the same instance each time. Easy mistake to make (lol !!!!) John -----Original Message----- Sent: 29 May 2002 20:34 To: Multiple recipients of list ORACLE-L This view is based on v$bh which is cumulative... So... YES! Regards, Michael Sale Author: Oracle9i for Windows(R) 2000 Tips & Techniques http://www.amazon.com/exec/obidos/ASIN/0072194626 -----Original Message----- Bryan Sent: Wednesday, May 29, 2002 11:19 AM To: Multiple recipients of list ORACLE-L Hello everyone, I am trying to track down excess pinging in an OPS cluster and I was looking at the contents of the v$ping table. I looked at the contents last night before I left and saw numbers in a fairly high range, but when I did the same query this morning the numbers were much lower than the previous night.Can someone tell me if the contents of the v$ping table cumlative or are they as of the the time of the query? Thanks, Bryan Rodrigues -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Michael P Sale INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: John Hallas INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Rodrigues, Bryan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
