Home » RDBMS Server » Performance Tuning » Statspack frequency
Statspack frequency [message #283948] |
Wed, 28 November 2007 07:44  |
orausern
Messages: 826 Registered: December 2005
|
Senior Member |
|
|
Hi,
Can you please convey what should be the ideal frequency for generatign Statspack reports? - We have production dbas generating statspack report for 12 hours period. But I read that over a lengthy interval, the report is not useful. Can you convey what are the disadvantages of lengthy interval for the STatspack and what should be the ideal interval?
Thanks,
Nirav
|
|
|
|
|
Re: Statspack frequency [message #283972 is a reply to message #283968] |
Wed, 28 November 2007 08:59   |
orausern
Messages: 826 Registered: December 2005
|
Senior Member |
|
|
I interacted with the DBAs who decided this interval. They said that , they decided this interval because the purpose is just to identify the SQLs that that are resource intensive. And so there is not much use of a shorter interval . They could have opted for a shorter interval if the users had complained of any performance issues. Since there is no such complaint, they asked the Prod. DBAs to collect these statspack manually at about 10 to 12 hours interval.
Can you comment whether this approach is right? - I just read at couple of places that the frequence should be in half an hour range and so I am getting the doubt whether this is appropriate or not.
Also thess setting are for production environment. Can you convey whether frequent collection of Statspack itself causes significant resource consumption in Production?
Thanks a lot,
Nirav
[Updated on: Wed, 28 November 2007 09:03] Report message to a moderator
|
|
|
|
|
|
Goto Forum:
Current Time: Mon Apr 28 13:31:57 CDT 2025
|