Segment Advisor

Segment Advisor : shrink 할 객체를 찾아줌

▣ Segment Advisor 연습

• 실전에서는 주기적으로 advisor 를 실행
• 연습에서는 segment 크기를 비 정상적으로 증가시킴

S SYS> alter table scott.dept shrink space;

alter table scott.dept shrink space

*

ERROR at line 1:

ORA-10636: ROW MOVEMENT is not enabled

   

   

S SYS> alter table scott.dept enable row movement;

   

Table altered.

   

S SYS> alter table scott.dept shrink space;

   

Table altered.

   

S SYS> analyze table scott.dept compute statistics;

   

Table analyzed.

   

▣ EM으로 처리

▣ Show SQL