OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » V$SYSSTAT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Attachment: V$SYSSTAT.TXT
(Size: 23.87KB, Downloaded 2188 times)

Report message to a moderator

Re: V$SYSSTAT [message #117763 is a reply to message #117760]

Fri, 29 April 2005 08:44

Frank Naude
Messages: 4596
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 11:59:58 CDT 2025