Sysaux Tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Sysaux Tablespace

  1. #1
    Join Date
    Dec 2007
    Location
    Buenos Aires - Argentina
    Posts
    31

    Sysaux Tablespace

    My tablespace Sysaux this growing quickly. Exists some way of purification to reduce the size? delete something, etc.

    Regards

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    How big is it?
    What's your retention policy?

    You can look at DBMS_LOGMNR_D.SET_TABLESPACE to move logminer tables to a different tablespace.
    You can lower retention policy.
    You can keep adding space to it.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Dec 2007
    Location
    Buenos Aires - Argentina
    Posts
    31
    Thanks, for response.
    In details is:
    select dbms_stats.get_stats_history_availability from dual; (01/11/07)
    select dbms_stats.get_stats_history_retention from dual; (31)
    The awr is default 7 days
    In addition, let me know, how i know the retention policy, and which is the procedure for moving tables to a different tablespace.

    The tablespace in four months grows 700MB and i can adding space.

    Thanks

  4. #4
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    You can query v$sysaux_occupants to check which is contributing more. The plan accordingly.
    http://www.perf-engg.com
    A performance engineering forum

  5. #5
    Join Date
    Dec 2007
    Location
    Buenos Aires - Argentina
    Posts
    31
    Thanks, Malay, but exist any way of reduce of size some occupants???
    LOGMNR 6080
    SM/AWR 123328
    SM/ADVISOR 171264
    SM/OPTSTAT 119360
    SM/OTHER 7552
    EM 105344

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by cjgrozo
    ... and which is the procedure for moving tables to a different tablespace.
    Look at DBMS_LOGMNR_D.SET_TABLESPACE.

    Quote Originally Posted by cjgrozo
    The tablespace in four months grows 700MB
    Not such a large increase in size.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Dec 2007
    Location
    Buenos Aires - Argentina
    Posts
    31
    thanks for all.

Posting Permissions

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



Click Here to Expand Forum to Full Width