oracle instance performance [message #436227] |
Tue, 22 December 2009 04:07 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|