This content has been marked as final. Show 2 replies
It doesnt analyze every database objects . Can you please check this Automatic Segment Advisory in "http://docs.oracle.com/cd/E11882_01/server.112/e10595/schema003.htm"
I have it running for 3.5 hours a night at the moment. Obviously, this is not enough to complete analysis of a 22Tb database in one night, but my question is whether it will continue where it was stopped the previous night or whether it will attempt to start again at the beginning.
Thanks for the link. It does indeed infer that the Segment Advisor does not start at the beginning again and continues where it left off:
"If an object is selected for analysis but the maintenance window expires before the Segment Advisor can process the object, the object is included in the next Automatic Segment Advisor run."