Re: Segment advisor

Posted by ErmanArslansOracleBlog on May 02, 2017; 7:00am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Segment-advisor-tp2619p2622.html

It may even be caused by object counts.. I mean;

suppose -> in t0 you had 120 tables
in t1 you run segment advisor and it did 80 recommendations
in t2 you dropped half of those tables
in t3 you run segment advisor and it did 40 recommendations :)

Something like this may even be the cause.
That is why, send me the recommendations and object names , so I can comment. (for both of the cases)