Home » RDBMS Server » Performance Tuning » statspack
statspack [message #64681] Mon, 22 December 2003 20:50 Go to next message
ashokmote
Messages: 56
Registered: December 2003
Member
i don't have any idea about statspack.were it is used,
how it is used.what is the use of statspack.were can i get good material on statspack
Re: statspack [message #64682 is a reply to message #64681] Mon, 22 December 2003 22:31 Go to previous messageGo to next message
Frank Naude
Messages: 4565
Registered: April 1998
Senior Member
Hi,

See http://www.orafaq.com/faqdbapf.htm#STATSPACK

Best regards.

Frank
Re: statspack [message #64787 is a reply to message #64681] Fri, 30 January 2004 13:18 Go to previous message
ilver
Messages: 50
Registered: January 2004
Member
Hi,

Think of statspack as looking at the database instance resource needs.
I.e. if you are concerned about instance tuning.
If you want to tune statements, queries and actions at that level, statspack won't do you any good copmpared to exetended SQL tracing and explain plans.

/ilver
Previous Topic: How to improve performance ?
Next Topic: How can I Improve Performance
Goto Forum:
  


Current Time: Thu Oct 01 03:27:18 CDT 2020