Oracle

How to deactivate segment advisor…

…Without Oracle Grid Control, unless would be too easy…

On very big databases segment advisor daily / week-end job is a performance killer and you normally never check the result or not more than around twice a year. So why not deactivate it and launch it manually on a small perimeter (per tablespace) and really work on the result ?

Continue reading