Home » RDBMS Server » Performance Tuning » V$SYSSTAT
V$SYSSTAT [message #117760] Fri, 29 April 2005 08:31 Go to next message
Messages: 70
Registered: February 2005
Location: Pune
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.

  • Attachment: V$SYSSTAT.TXT
    (Size: 23.87KB, Downloaded 1524 times)
Re: V$SYSSTAT [message #117763 is a reply to message #117760] Fri, 29 April 2005 08:44 Go to previous message
Frank Naude
Messages: 4578
Registered: April 1998
Senior Member

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.

Previous Topic: Rollback segment error in production HELP
Next Topic: Deleting from Huge table
Goto Forum:

Current Time: Wed Feb 21 08:21:45 CST 2024