Home » RDBMS Server » Performance Tuning » oracle instance performance (oralce 9i , Linux)
oracle instance performance [message #436227] Tue, 22 December 2009 04:07 Go to next message
chuikingman
Messages: 90
Registered: August 2009
Member
Hi,
I use oracle 9i in linux.
I have several instance running in it .
How can I check the perormance of the instance is good or bad ??
What subject and how I can check to monitor the performance of these instance ???
Pleae give me more detailed information
Re: oracle instance performance [message #436237 is a reply to message #436227] Tue, 22 December 2009 05:15 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How can I check the perormance of the instance is good or bad ??

Run statspack (see sp* files in ORACLE_HOME/rdbms/admin dir).
But if no one is complaining about performances then performances are good.

Regards
Michel
Previous Topic: Update statement query tuning
Next Topic: Deadlock interpretation
Goto Forum:
  


Current Time: Thu Dec 08 22:10:01 CST 2016

Total time taken to generate the page: 0.11196 seconds