0 Replies Latest reply: Mar 7, 2013 10:34 AM by notnovice RSS

    Want to know how job to purge statspack works

    notnovice
      Debugging job for statspack purge, Running 11g OMS , 10.2.0.4 Agent against 9.2.0.4 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.
      Thanks