Home » RDBMS Server » Performance Tuning » Statspack Report (9.2.0.6.0 IBM AIX)
Statspack Report [message #315425] Mon, 21 April 2008 08:04 Go to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

Hi All,

Please let me know is there is any document for details analysing the SPREPORT.

I have generated one report through SPREPORT.SQL but failed to analyse the report as I dont have the clear idea about the same.

Please help

Pokhraj
Re: Statspack Report [message #315431 is a reply to message #315425] Mon, 21 April 2008 08:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
spdoc.txt?

Regards
Michel
Re: Statspack Report [message #315436 is a reply to message #315425] Mon, 21 April 2008 08:49 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

yes
Re: Statspack Report [message #315477 is a reply to message #315425] Mon, 21 April 2008 12:48 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
Analyzing Statspack report is a specialised job.
Its better to first grasp the terminlogies that are used in statspack report.

For example,CBO,RBO,db file sequential read,scattered read,waits,events,I/O....the list goes on.


Previous Topic: more reloads
Next Topic: Performance isssue
Goto Forum:
  


Current Time: Wed Dec 07 02:53:47 CST 2016

Total time taken to generate the page: 0.07948 seconds