Sunday, February 24, 2013

1 Segment Advisor & Undo Advisor

Segment Advisor

Segment advisor is the job that oracle use to detect the unused space and advise DBA can reclaim the space. The segment advisor is now part of automatic maintenance job.

 

image

image

image

Undo Advisor

To enable the Automatic Undo management ( AUM), we need to set up below 3 parameters. Please see here for more detail.

 

image_thumb[5]

image_thumb[3]

image_thumb[1]

 

Reference

1 comments:

  1. Robo advisor

    The definition of a robo-advisor is an automated program that provides financial advice. More precisely, the program manages your investments through an automated algorithm rather than having a person monitoring your portfolio.
    https://www.themoneypouch.com

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates