Re: Need Statspack help

From: Paul Widner <paul_widner_at_hotmail.com>
Date: Wed, 20 Oct 2004 08:48:24 -0700
Message-ID: <mNvdd.3$v02.24415@news.uswest.net>

"Paul Drake" <bdbafh_at_gmail.com> wrote in message news:910046b4.0410191944.785046d9_at_posting.google.com...
> paul_widner_at_hotmail.com (PaulW) wrote in message
news:<3fdda837.0410191359.515564bb_at_posting.google.com>...
> > We have collected the following stats pack report, could someone give
> > me some feedback on it? Any help would be great! Thanks, Paul
>
> tune the app sql.
>
> large amount of full table scans.
> check v$sql_plan for full table scans, as well as v$session_longops.
>
> 350 physical reads/second (how many controllers, disks?)
> 10 msec avg duration per wait on db file scattered read, sounds like a
> longish queue on new disks - it should be half of that.

They UNIX SysAdmin told me the drives are running on a SAN with 5 drives in a RAID 5 configuration. The SAN is connected via fiber channel. All DB operations are on this one volumn. Do you think this could be a problem?

>
> also, apply the 9.2.0.5 patchset and whatever patchsets are applicable
> for your platform as covered in Security Alert #68.
>
> -bdbafh
Received on Wed Oct 20 2004 - 10:48:24 CDT