Re: Statspack

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 28 Apr 2004 14:54:42 -0700
Message-ID: <1ac7c7b3.0404281354.4721d522@posting.google.com>

"Mill" <mill.h_at_ntlworld.com> wrote in message news:<9mPjc.305$fp.243_at_newsfe6-gui.server.ntli.net>...
> Have just run statspack on a oracle 8.1.7.4 DB on windows 2k with 2gb RAM,
> can anybody see
> anything in the results i need to be concerned about ?
>
> Appreciate any comments/tips
>

yes.
you have confused comp.databases.oracle.server with oraperf.com. why don't you upload the statspack report output there, and see what Anjo's YAPP magic 8 ball says?

your buffer cache seems low.
your dbfmbrc seems high.
when you perform a 10046 trace against a statement that executes a full table scan, how many blocks are read at a time?

Pd Received on Wed Apr 28 2004 - 16:54:42 CDT