Results 1 to 4 of 4

Thread: Statspack

  1. #1
    Join Date
    Mar 2004
    Location
    India
    Posts
    87

    Unanswered: Statspack

    Hi,
    I wish to use statspack to find out top segments for Logical Read/Physical Reads etc for a particular day. I have enabled statspack data collection for every hour through a job. Will the data I need be available to me if I give day's first snap_id and last snap_id as begin and end snapshots for the statspack to run for?
    Will it be accurate if 24hrs duration top segments are found using this.
    Or does it find for snapshot 1 and snapshot 2 and the top amongst them and not the top ones for the duration involved between the two.

  2. #2
    Join Date
    Mar 2004
    Location
    India
    Posts
    87
    I mean not necessarily top segments but say top sqls as well.
    My aim would be to find top sqls(say) for teh whole of the past day

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    find top sql for the hour that is the busiest for your day.
    If you have the most activity between 2-4pm then run
    a spreport.sql for the snap_ids from 2-3pm and for 3-4pm.

    If you run 1 report for the whole day I don't see how you could use
    the information as effectively as hourly (or try every 30 mins).
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Mar 2004
    Location
    India
    Posts
    87
    Thank You!

Posting Permissions

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