Results 1 to 2 of 2

Thread: statspack

  1. #1
    Join Date
    Jan 2004

    Unanswered: statspack

    I am keen on working with statspack. I have a query though.
    Snap_Ids indicate the points for which the statspack report can be generated for analysis. But if I have automated the data collection using dbms_job and it is running every hour , how do I find the snap ids for time interval for say 02:00 hrs and 04:00 hrs tomorrow morning if I am told the performance was poor during that time.
    Any help would be greatly appreciated.

  2. #2
    Join Date
    Jul 2003
    when you run $ORACLE_HOME/rdbms/admin/spreport.sql as the perfstat user, you will then be given a list of ALL snap_ids and their timestamp.

    Pick the beginning and ending snap corresponding to the timestamp/date you desire.

    ps: I think you meant to say YESTERDAY from 2-4pm and not TOMORROW.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts