Thanks John,
that's what I thought, but I just wasn't sure if it applied for the ratio's
as well,
Jim
-Original Message-
Sent: 31 January 2002 12:55
To: Multiple recipients of list ORACLE-L
HI James,
This will tell you these percentages during the time you are reporting on.
John
[EM
HI James,
This will tell you these percentages during the time you are reporting on.
John
[EMAIL PROTECTED] wrote:
>Hi,
> I just want to check something about statspack. Might seam like a silly
>question, but I just want to check.
>
>In the Instance Efficiency section, you have the hit ratios.
Hi,
I just want to check something about statspack. Might seam like a silly
question, but I just want to check.
In the Instance Efficiency section, you have the hit ratios. Normally when
people check these, it is from instance startup. I was just wondering if
statspack is the same, or does it wo
Hi Greg,
I had already covered the part of getting down to the
SQL earlier in my response.
Gaja
--- Greg Moore <[EMAIL PROTECTED]> wrote:
> > so long as you look at the wait events, you will
> > be looking at your database's bottlenecks, and in
> the
> > world of Oracle Performance Tuning, that
i would probably first use v$sqlarea instead of v$sql
to be able to identify the hash values for bad
ones(high lio's) and then probe v$sql using the same.
Deepak
--- Greg Moore <[EMAIL PROTECTED]> wrote:
> > so long as you look at the wait events, you will
> > be looking at your database's bottle
> so long as you look at the wait events, you will
> be looking at your database's bottlenecks, and in the
> world of Oracle Performance Tuning, that is all that
> counts.
What about v$sql?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Greg Moore
INET: [EMAIL PROT
Hi Bill,
Cache-hit ratios are probably one of the most
irrelevant and misleading metrics that one has to deal
with in the Oracle performance tuning space. You have
real proof in your hands in the form of 2 statspack
reports. Yes you are comparing apples to oranges, as
the performance health of an
Howdy,
I must not know what I'm doing here. I ran a Statspack report for 2
different periods of time, each an hour long. In the first case, my instance
efficiency percentages look pretty bad. They look like this:
Instance Efficiency Percentages (Target 100%)
~
Hello all,
I recently created some Level 5 Statspack snapshots for an Oracle
8.1.7.0 database. Here's a portion of a snapshot report:
Instance Efficiency Percentages (Target 100%)
~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit