Home » RDBMS Server » Performance Tuning » Wait events (9i ( Windows 2003)
Wait events [message #358508] Tue, 11 November 2008 11:53 Go to next message
Messages: 114
Registered: June 2008
Senior Member
The database server is with performance issues.
A very lot of I/O.
The cart of statistcs show the following events:

- Buffer busy wait
- db file sequential read
- db file scattered read

Server: Windows 2003 server
Memory: 3G
SGA: 400M
Buffer cache: 100M
Active session: 60

Some suggestions?

Marcos Santos
Re: Wait events [message #358518 is a reply to message #358508] Tue, 11 November 2008 12:32 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Performance Tuning Guide
Chapter 10 Instance Tuning Using Performance Views
Section 10.3 Wait Events Statistics

Previous Topic: Dunsel Joins
Next Topic: Performance tuning for a simple table with 2million records
Goto Forum:

Current Time: Sun Aug 20 12:30:05 CDT 2017

Total time taken to generate the page: 0.06801 seconds