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

Report message to a moderator

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: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
spdoc.txt?

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 12:44:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.