Oracle-L: RE: Question on V$ping table

From: Rodrigues, Bryan <BRodrigues_at_elcom.com>
Date: Wed, 29 May 2002 15:01:13 -0800
Message-ID: <F001.0046EF08.20020529150113@fatcity.com>

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: BRodrigues_at_elcom.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

--

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

Author: Michael P Sale
INET: Michael.Sale_at_oracle.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

--

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

Author: John Hallas
INET: john.hallas_at_hcresources.co.uk

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: Rodrigues, Bryan
INET: BRodrigues_at_elcom.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