Home » RDBMS Server » Performance Tuning » statspack-buffer waits
icon5.gif  statspack-buffer waits [message #129545] Mon, 25 July 2005 13:20 Go to next message
rkl1
Messages: 97
Registered: June 2005
Member
Hi All,

on statspack report, we see the file I/O stats which gives info about the tablespace, datafiles with reads and writes per second. Also we have some info there aobut the buffer waits and avg.buffer waits for each data file.What the buffer waits exactly mean. Is it same as free buffer waits? If we have different datafiles with different buffer waits, does high buffer waits translate to poor performance as that particular data file has been swapped. How to reduce the buffer waits particularly.

thanks.
Re: statspack-buffer waits [message #129656 is a reply to message #129545] Tue, 26 July 2005 03:36 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

http://www.oracle.com/technology/oramag/oracle/03-jan/o13expert.html

Regds
Girish
Re: statspack-buffer waits [message #129722 is a reply to message #129656] Tue, 26 July 2005 07:24 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Girish. That is good document!.

Previous Topic: Performance on DB Link
Next Topic: How increase OLTP regarding more CPU?
Goto Forum:
  


Current Time: Thu Mar 28 19:44:50 CDT 2024