Ah but then everything is fine ... Could we suggest buying a bigger machine :-) ?
- --- Original Message --- -
From: Jared Still [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Mon, 11 Aug 2003 07:44:23
But his BCHR is 99.57% !
On Sun,
Jared,
LIO being high and BHCR ~ 99% : is this is a normal
or abnormal ?
Regards,
Jp.
12-08-2003 00:44:23, Jared Still
[EMAIL PROTECTED] wrote:
But his BCHR is 99.57% !
OK, let's have another try at it. Let's say that you are a travelling salesman, with a
number of prospects to visit at a
Profile(sex,entpc,laccess) and profile(sex,entpc,faccess)
Would appear to be called for. Obviousdly you will wish to analyze the
schema, and even more obviously you will do all this in test first.
If sex is a column that does not have many values (one would think no
more than 8 or so) then you
Thanks a lot Stephane.
There are indexes on profile table which u pointed
out.
but none of the tables/indexes are analyzed yet.
First thing to do.
Connor pointed that there are 54million consistent
gets.
LIO is high.
does it mean that db_cache_size (700M) is small ?
how to deal with this ?
Thanks a lot Millsap,Stephane Faroult,Jared Still,Wolfgang,Tanel and Dennis for
your pointers and suggestions.
I owe a lot to you Oracle Gurus.
A novice DBA like me is ever grateful to this wonderful list.
I love this list.
Thanks once again.
Jp.
--
Please see the official ORACLE-L FAQ: