Re: How long should statspack.snap take to run?

jon.fife_at_gmail.com wrote:
> Hi all,
>
> I've been tossed into a vacant DBA role and I'm trying to pick up the
> pieces the former DBA left in his wake. It doesn't seem that he had any
> sort of history for performance baselines, so I've been playing around
> with statspack. When I do the statspack.snap it takes around 15 minutes
> to complete and I was just wondering if that was outrageous or typical.
> It is a 9.2.0.4 server with roughly 150GB of data and 150 concurrent
> users during the day doing OLTP. I've done some googling to see if the
> time spent was sane, but didn't find much there. It seems some people
> set up statspack to run every 30 minutes or so, which makes 15 minutes
> seem high...

To answer your question, which the first 2 people responding did not bother to do is that yes 15 minutes is a problem doing a level 5 snap. It should be much much faster.

Tell us a little more about your system? What os, how much memory, how many cpu's ... do you have extra cpu capacity during those times when you are taking snapshots or is your system totally maxed out?

You might want to clean up the statspack stuff by dropping and re-installing the tables and stuff for statspack. Received on Fri Jul 14 2006 - 20:16:50 CDT