Re: Need Statspack help

From: Paul Drake <bdbafh_at_gmail.com>
Date: 19 Oct 2004 20:44:36 -0700
Message-ID: <910046b4.0410191944.785046d9@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.

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 Tue Oct 19 2004 - 22:44:36 CDT