Statspack question

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

Re: Statspack question

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.

RE: Statspack question

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

Re: Statspack Question

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

Re: Statspack Question

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

Re: Statspack Question

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 is all

Statspack Question

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%)

Re: Statspack Question

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

Statspack question - Execute to Parse %

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