Re: Addressing buffer buisy waits in 10g with ASSM
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <saad4u@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 Sep 2012 10:10:28 +0100
From your comment it looks like you're looking at the v$waitstat output
(possibly as reported by AWR or Statspack).
Two points: I think this may include "read by other session" when it
shouldn't, and you need to look at the "Segments by .... " section of the
report to identify exactly which segments are subject to the problem.
It would also be interesting to see the "Top 5" report to see the relative
impact made by the buffer busy waits - you don't anything about time spent,
only about counts.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com/all_postings
Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543
----- Original Message -----
From: "Saad Khan" <saad4u@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Sunday, September 16, 2012 5:48 PM
Subject: Addressing buffer buisy waits in 10g with ASSM
| Hi all,
| We've a Oracle 10gR2 environment on AIX 6.1. I'm seeing a lot of buffer
| buisy waits and mostly on data segment headers. When I try to add more
| freelists to the buisy segments, it doesnt let me do that being in ASSM
| mode.
|
| What are the other options that I can utilize in overcoming this?
|
| Any help is appreciated.
|
| Thanks.
|
|
| --
| //www.freelists.org/webpage/oracle-l
|
|
|
--
//www.freelists.org/webpage/oracle-l
Other related posts:
