Segment Advisor in 11g
I have recently enabled the Segment Advisor in my 11gR2 Exadata database (automated maintenance tasks were disabled when we first went live).
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.
It's run about five times so far, but has only analyzed one tablespace. I suspect I'm being unrealistically impatient and its just taking a while to get through one tablespace, but am worried that it will be stuck analyzing the same part of the database forevermore without my intervention...