Statspack execution time
My statspack snap execution takes 8 to 10 minutes, ( Sometimes 12 minutes !!!! ). Experts suggests to take snaps after each 15 minutes when the load is more on the database. But how effective would be the analysis using statspack report effective if snap takes 8 to 10 min.
Can you share everybody what time it takes to execute there statspack snap.
My Snap level is 5 (Default).
Database Oracle 8i 22.214.171.124 on Solaris 8 with 8 CPU and 8 GB RAM.
Catch me online at Yahoo: ddpatel256