Uhmmm. 8.5E-06, to the best of my recollection is scientific notation for .0000085 which is less than 3 percent. Of course, with all the talk about Heisenberg today, I'm uncertain. Better find Schrodinger's cat and ask it.
Kevin Kennedy
First Point Energy Corporation
-----Original Message-----
Sent: Wednesday, July 03, 2002 3:22 PM
To: Multiple recipients of list ORACLE-L
So this is not good:
CHILD# RATIO
------- -------
16 8.5E-06
15 .000013
14 7.5E-06
13 6.5E-06
12 8.2E-06
11 .00001
10 9.3E-06
9 9.1E-06
8 8.4E-06
7 .000012
6 9.5E-06
5 8.5E-06
4 9.8E-06
3 9.1E-06
2 8.9E-06
1 .000008
16 rows selected.
Enter value for child_latch_number: 16
old 3: WHERE lo_setid <= &&child_latch_number
new 3: WHERE lo_setid <= 16
old 4: AND hi_setid >= &&child_latch_number
new 4: AND hi_setid >= 16
NAME
KEEP
RECYCLE
DEFAULT
At 01:07 PM 7/3/2002 -0800, Jared.Still_at_radisys.com wrote:
>If you aren't experiencing performance problems, the best thing to do
>is nothing.
>
> >From the docs ( Designing and Tuning for Performance )
>
>To determine whether your system is experiencing latch contention, begin
>by determining whether there is LRU latch contention for any individual
>latch.
>
>SELECT CHILD#, SLEEPS / GETS RATIO
>FROM V$LATCH_CHILDREN
>WHERE NAME = 'cache buffers lru chain';
>
>
>The miss ratio for each LRU latch should be less than 3%. A ratio above 3%
>for any particular latch is indicative of LRU latch contention and should
>be addressed.
>You can determine the buffer pool to which the latch is associated as
>follows:
>
>SELECT NAME
>FROM V$BUFFER_POOL
>WHERE lo_setid <= child_latch_number
>AND hi_setid >= child_latch_number;
>
>Jared
>
>
>
>
>
>
>Hamid Alavi <hamid.alavi_at_quovadx.com>
>Sent by: root_at_fatcity.com
>07/03/2002 08:58 AM
>Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:
> Subject: db_block_lru_latches
>
>
>List,
>
>I have a question regarding db_block_lru_latches, I have read in some
>book(can't remember) which the best number for this parameter is (number
>of
>CPU)*6 or db_block_buffers/50.
>But these two result is diffrent,anybody have any idea what's the best
>configuration for this parameter.
>In my configuration it has been set to 1 as default and I have two CPU so
>it
>means it should be 6*2 = 12?is it right?
>Thanks allot for your recommendation.
>
>
>
>
>
>Hamid Alavi
>Office 818 737-0526
>Cell 818 402-1987
>
>
>
>
>
>
>======================= Confidentiality Statement =======================
>The information contained in this message and any attachments is
>intended only for the use of the individual or entity to which it is
>addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
>and exempt from disclosure under applicable law. If you have received
>this message in error, you are prohibited from copying, distributing, or
>using the information. Please contact the sender immediately by return
>e-mail and delete the original message from your system.
>===================== End Confidentiality Statement =====================
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Hamid Alavi
> INET: hamid.alavi_at_quovadx.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:
> INET: Jared.Still_at_radisys.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: Deborah Lorraine
INET: dlorraine_at_ucdavis.edu
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: kkennedy
INET: kkennedy_at_firstpoint.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 Wed Jul 03 2002 - 18:23:21 CDT
