Segment advisor

[Arsalan]

Sir.

I want to know about why segment adviser recommendation sometime 70 objects and sometime 30 why it increase and decrease kindly guide me



Thanks

Arsala

[ErmanArslansOracleBlog]

Hi Arsala,

What are those recommendations?

If you can show me the recommendations, then I can comment.

[ErmanArslansOracleBlog]

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)

[ErmanArslansOracleBlog]

Also there are reported cases ->

Segment Advisor Recommendations Showing Non-Existing Tables (Doc ID 456616.1)
Segment Advisor Recommendation does not get cleaned After Implementing it (Doc ID 1540915.1)

Take a löook at these types of notes as well..