| oracle instance performance [message #436227] |
Tue, 22 December 2009 04:07  |
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  |
 |
Michel Cadot
Messages: 68650
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
