| V$SYSSTAT [message #117760] |
Fri, 29 April 2005 08:31  |
milind_sri
Messages: 70
Registered: February 2005
Location: Pune
|
Member |
|
|
Hi Gurus,
I am sending you the spool file of V$SYSSTAT view of my database.I cant understand the entries in this view and dont know which is hampering the performance of my database. I dont know on which parameters should i concentrate and try to keep the value of those parameters as low as possible.
I need suggestions from you people regarding this that on which paramteres I should concentrate so that I can have performance benefits for my database.
Any help is appreciated. Thanks in advance.
Pls. find the file as attachment.
Milind.
|
|
|
|
| Re: V$SYSSTAT [message #117763 is a reply to message #117760] |
Fri, 29 April 2005 08:44  |
Frank Naude
Messages: 4593
Registered: April 1998
|
Senior Member |
|
|
Hi,
V$SYSSTAT is not the best place to start looking for performance problems and potential gains. Rather take a couple of STATSPACK snapshots and analyse the output.
If you are running 10g, login to Database Control and use the ADDM facilities to analyse your database's performance.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
