snap ids to generate performance report
498879Feb 28 2007 — edited Feb 28 2007Hi,
I have a basic idea on statspack, and implementing this first time, looking for your help to generate statspack report.
scenario is this :-
we have to do a performance testing during bulk loading which happens daily at night for 1 hour.
i have sheduled a job to generate snaps on every interval of 15 min say :-
NAME SNAP_ID Date/Time
--------- ---------- ---------------------------
oracle 4 13.11.2006:08:45:00
oracle 1 13.11.2006:08:00:00
oracle 2 13.11.2006:08:15:00
oracle 3 13.11.2006:08:30:00
suppose at 08:00 there is no loading so i am considering this as a baseline snap ,
so, which snap ids i have to include to generate various performance report (like sp_1_2,sp_1_3,sp_14 etc) .
Asif