Home » RDBMS Server » Performance Tuning » Wait events (9i (9.2.0.1) Windows 2003)
Wait events [message #358508] Tue, 11 November 2008 11:53 Go to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,
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: 64139
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

Regards
Michel
Previous Topic: gets,pins and reloads in v$library Cache
Next Topic: Dunsel Joins
Goto Forum:
  


Current Time: Thu Dec 08 14:29:11 CST 2016

Total time taken to generate the page: 0.11093 seconds