Home » RDBMS Server » Performance Tuning » V$SYSSTAT
V$SYSSTAT [message #117760] Fri, 29 April 2005 08:31 Go to next message
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.
  • Attachment: V$SYSSTAT.TXT
    (Size: 23.87KB, Downloaded 814 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: 4565
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
Previous Topic: Rollback segment error in production HELP
Next Topic: Deleting from Huge table
Goto Forum:
  


Current Time: Sun Sep 20 23:01:44 CDT 2020