Results 1 to 2 of 2

Thread: ASH data purge

  1. #1
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    Unanswered: ASH data purge

    Hello members,

    I am using Oracle 11g r2


    my v$active_session_history view data is getting purged in an unpredictable manner . sometimes in 2 days or times in 10 days. I am no able to reach the root cause.

    Is there any way to retain that permanently or for a long time guaranteed say 1 month

    any clues ?

    thanks
    sumit
    ssumit

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    AUDIT DELETE on underlying tables to learn who makes rows go missing.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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