var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: segment advisor
what is the use of runing following procedure inside dbms_space???
what this procedure is actually doing???
i found "Automatic Segment Advisor is implemented by the AUTO_SPACE_ADVISOR_JOB job. This job executes the DBMS_SPACE.AUTO_SPACE_ADVISOR_JOB_PROC procedure at predefined points in time."
but not getting anything...
anyone can plss explain me
Have you examined the view?:
Oracle DBA_AUTO_SEGADV_SUMMARY view can be used to display the information specific to Automatic Segment Advisor. Each row of this view summarizes one Automatic Segment Advisor run
90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.