uot;fixing" the
BHR.
- Kirti
-Original Message-
Sent: Wednesday, October 09, 2002 9:19 PM
To: Multiple recipients of list ORACLE-L
...and a high cache hit ratio (>99%) is usually an indication of a
serious problem as well.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
...and a high cache hit ratio (>99%) is usually an indication of a
serious problem as well.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Oct 15-17 Dallas, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dal
;
cc:
Subject: RE: Cache hit ratio?
Seema
1. How low is too low? Basically, different applications will tend to
have
different BHR values (Buffer Hit Ratio).
2. BHR varies over time, and will depend a lot on the lengths of time
you
sample it, and what type of processing was run
October 09, 2002 4:14 PM
To: Multiple recipients of list ORACLE-L
Hi
One of my database Cache Hit Ratio is low.I adjusted db_block_buffer and I
have noticed after week again cache hit ratio became low.
Can u please suggest what other things I can do to fix this problem?
]
10/09/02 02:13 PMcc:
Please respond toSubject: Cache hit ratio?
ORACLE-L
> Sent: Wednesday, October 09, 2002 2:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Cache hit ratio?
>
>
> Hi
> One of my database Cache Hit Ratio is low.I adjusted
> db_block_buffer and I
> have noticed after week again cache hit ratio became low.
> Can
Seema Singh wrote:
>
> Hi
> One of my database Cache Hit Ratio is low.I adjusted db_block_buffer and I
> have noticed after week again cache hit ratio became low.
> Can u please suggest what other things I can do to fix this problem?
> Thx
> -Seema
Use Connor's scri
Hi
One of my database Cache Hit Ratio is low.I adjusted db_block_buffer and I
have noticed after week again cache hit ratio became low.
Can u please suggest what other things I can do to fix this problem?
Thx
-Seema
_
Chat with
If you will search Metalink you will see that this bug is generic and not
specific to a certain system.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, September 16, 2002 7:58 PM
> Guys, the 2429929 apply for Sun Solari
Title: Nasty bug in 9.2.0.1 (was: Oracle and Cache Hit Ratio based training)
You should call your sales persons and start
applying pressure for them to provide a correction to 9ir2.
I am doing this right now.
Yechiel AdarMehish
- Original Message -
From:
[EMAIL PROTECTED
Title: Nasty bug in 9.2.0.1 (was: Oracle and Cache Hit Ratio based training)
FWIW
There is a document (id 283852) on Metalink updated on 03-SEP-2002 created by "CENTER OF EXPERTISE" named
THE COE PERFORMANCE METHOD
A PERFORMANCE METHODOLOGY FOR ENTERPRISE-WIDE INFORMATION SYSTE
Performance Tuning 102 dear, Performance Tuning 102
--- "Fink, Dan" <[EMAIL PROTECTED]> wrote:
> I can see it now...
> DBA 102:Buffer Cache Wait Hit Ratio Interface Tuning...
>
> -Original Message-
> Sent: Monday, September 09, 2002 12:13 PM
> To: Multiple recipients of list ORACLE-L
>
Hi all,
I have a large data load to run into a partitioned table. With indexes the
load takes
over 24 hours, without on the order of 3 hours, obviously, I don't want to
mess with
the indexes until after the job completes. So I try to drop to local
indexes and get
ORA-14076. Fair enough. I g
I can see it now...
DBA 102:Buffer Cache Wait Hit Ratio Interface Tuning...
-Original Message-
Sent: Monday, September 09, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L
FWIW ...
One of our DBAs just got back from a Oracle 9i course
and it was stated by the instuctor that Oracl
FWIW ...
One of our DBAs just got back from a Oracle 9i course
and it was stated by the instuctor that Oracle is in the
process of revamping all their performance classes to
be based on the wait interface.
Looks like Cache Hit Ratios may finally go away !!!
--
Please see the official ORACLE-L
Hi,
> You missed it, it seems that you were an hour late.
> You can download it from www.precise.com.
When the archives appear there? It's still in "pre-register" state.
Alexandre
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexandre Gorbatchev
INET: [EMAIL PROT
f someone has already posted this to the list today, I just haven't
> had time to read it yet today.
>
> Jared
>
> -
>
> SearchEBusiness invites you to this Vendor Connection Webcast:
>
> ***********
Thanks Jared,
Drinks are on me ;-)
[EMAIL PROTECTED] wrote:
Ok, everybody, let's show up in support of Anjo.This should be a great presentation. Sorry if someone has already posted this to the list today, I just haven'thad time to read it yet today.Jared-SearchEBusiness invi
Well no Jacques, here's your chance to see what
the competition is up to. :)
Jared
On Friday 02 August 2002 15:59, Jacques Kilchoer wrote:
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> >
> > Ok, everybody, let's show up in support of Anjo.
> >
> > This
Title: RE: Live Webcast: The death of the buffer cache hit ratio
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> Ok, everybody, let's show up in support of Anjo.
>
> This should be a great presentation.
>
> Sorry if someo
on Webcast:
*
TOPIC: The death of the buffer cache hit ratio
WHEN:Wednesday, August 7 at 11:00 a.m. EDT (15:00 GMT)
SPEAKER: Anjo Kolk, Chief Oracle Technologist, Precise Software and
renowned Oracle performance author
SPONSO
IL PROTECTED] wrote:
>
> >If you buffer cache hit ratio is <90% you're
> experiencing poor performance
> >and you're a DBA wimp. :-)
> >
> hi, i'm bill and i'm a compulsive database tuner.;-)
>
>
> --
> --
> B
Infact one of our production database (8.0.x) has a buffer cache hit ratio of 2%
for the last 2 years. All others are about 90%+.
Strange thing is that users are so happy with the performance of this database
with 2% hitratio, they do not want us to increase the buffer cache!!
Rama
Rachel
buffer cache hit ratio
Ramon,
if you find the performance of the database is good, why are you trying to
fix it??
Cache Hit Ratio is not the be-all and end-all of tuning. If the cache hit
ratio is high, and you have large numbers of wait events, then your database
needs tuning.
If the
Ramon,
if you find the performance of the database is good, why are you trying to
fix it??
Cache Hit Ratio is not the be-all and end-all of tuning. If the cache hit
ratio is high, and you have large numbers of wait events, then your database
needs tuning.
If the cache hit ratio is low
Interesting. In 8.1.7 32-bit oracle binary, select * from v$type_size where
type = 'UB4' tells me it's 4 bytes. So it's 32 bit and the maximum is 4
billion.
Glad to see Jonathan on this forum.
Yong Huang
[EMAIL PROTECTED]
you wrote:
> From: K Gopalakrishnan
>
> Welcome Jonathan,
>
> I think mo
Enviado el: Tuesday, 07 August, 2001 5:07 PM
Para: Multiple recipients of list ORACLE-L
Asunto: RE: negative value for buffer cache hit ratio
Hi,
Generally speaking.. HIT RATIOS does not give the true
picture always. I have seen databases performing
extremely good with 50% and bad databases with 99%
es available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html
-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 07 August 2001 19:52
|
|Dear gurus !
|I have a negative value for buffer cache hit ratio in my DB which is
u
Hi Christopher !
SQL> select to_char(100 * misses / (hits + misses), '9990.00') || '%'
miss_rate
2from ( select total_waits misses
3from sys.v_$system_event
4 where event = 'db file sequential read' ),
5 ( select sum(dbbget + conget - pread) h
hit ratio'. And
got
a hit on 'MROC: I am receiving a negative Buffer Cache hit ratio' thread.
You may want to check it out, there seems to be a new formula for hit ratio
computation in 8i/9i.
HTH,
Regards,
- Kirti Deshpande
Verizon Information Services
http://www.superpage
Hi,
Generally speaking.. HIT RATIOS does not give the true
picture always. I have seen databases performing
extremely good with 50% and bad databases with 99% hit
ratio.
You should never decide the database performance based
on hit ratio and 90% hit ratio does not mean that 90%
of the data is AL
.
The difference here is it takes in account of direct writes.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 3
their shoes."
Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-Original Message-
Sent: Tuesday, August 07, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L
Welcome Jonathan,
I think most of the counter are limited by ub4maxval
and that makes the negative hit ratio.
Welcome again !
--- Jonathan Lewis <[EMAIL PROTECTED]>
wrote:
>
> It is possible that after 4 months your stats
> have wrapped around the ( ? 64 bit ?) limit
> value for y
E MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-Original Message-
Sent: Tuesday, August 07, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L
Dear gurus !
I have a negative value for buffer cache
of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html
-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: 07 August 2001 19:52
|
|Dear gurus !
|I have a negative value for buffer cache hit ratio i
Nothing is wrong in your database.
You don't have the required X_$ views created. Change
X_$ to X$ or create X_$ views as select * from X$
views.
=
Have a nice day !!
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
_
le recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Andrey,
I am not into cache hit ratios, but got curious about your negative value.
So I casually searched Metalink for 'negative value for hit ratio'. And
got
a hit on 'MROC: I am receiving a negative Buffer Cache hit
n you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-Original Message-
Sent: Tuesday, August 07, 2001 1:51
for 'negative value
> for hit ratio'. And got
> a hit on 'MROC: I am receiving a negative Buffer
> Cache hit ratio' thread.
> You may want to check it out, there seems to be a
> new formula for hit ratio
> computation in 8i/9i.
>
> HTH,
Andrey,
I am not into cache hit ratios, but got curious about your negative value.
So I casually searched Metalink for 'negative value for hit ratio'. And got
a hit on 'MROC: I am receiving a negative Buffer Cache hit ratio' thread.
You may want to check it out, the
age-
Sent: Tuesday, August 07, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L
Dear gurus !
I have a negative value for buffer cache hit ratio in my DB which is up for
some 4 months . Any ideas why ? Thanks in advance.
SQL> SELECT (1 - (SUM(DECODE(a.name,'physical reads'
Dear gurus !
I have a negative value for buffer cache hit ratio in my DB which is up for
some 4 months .
Any ideas why ?
Thanks in advance.
SQL> SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) /
2 (SUM(DECODE(a.name,'consistent gets',value,0)) +
3 SUM(
43 matches
Mail list logo
