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: 64953
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: gets,pins and reloads in v$library Cache
Next Topic: Dunsel Joins
Goto Forum:

Current Time: Sat Jun 24 21:11:24 CDT 2017

Total time taken to generate the page: 0.07714 seconds