Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: Oracle AWR retention period

    Hi,
    I have a AWR retention period of 7 days, now I want to increase it to 60 days.

    The tabespace SYSAUX is configured like this:

    TABLESPACEYSAUX
    SpaceTotal(MB): 5000
    AutoExtend: YES
    MaxSize(MB): 15.000

    I'd like to know if there could be problems of growth on Tablespace SYSAUX with a retention period of 60 days, and if we can predict that growth.

    Thanks in advace!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Which schema owns the AWR data & how much spaces is now consumed by it?
    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.

  3. #3
    Join Date
    Jul 2002
    Posts
    227
    Quote Originally Posted by anacedent View Post
    Which schema owns the AWR data & how much spaces is now consumed by it?
    Now the space consumed is 4 GB, seems that utlsyxsz.sql (held in $ORACLE_HOME/rdbms/admin) will estimate the required size for the SYSAUX tablespace based on the retention period, but I can't run this package on production environment.



    Have you any idea?



    Thanks!

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >but I can't run this package on production environment.
    Why not?
    Your QA database should match what is in Production, so run the utlsyxsz.sql procedure in QA DB.
    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
  •