0 Replies Latest reply on Mar 7, 2013 4:34 PM by notnovice

    Want to know how job to purge statspack works

      Debugging job for statspack purge, Running 11g OMS , Agent against database. Job setup to retain 14 days of snapshots.
      Log shows 2 numbers at very start of job (I assume these are the calculated low & high
      snap id's which would leave X no days retained.
      What exactly is the agent running (perl script) that I can look at ?
      It appears to be a 2 step process, 1 determines the range and 2 is running the sppurge.sql
      from the rdbms/admin folder.