58. Exhibit

Using Database Control, you have scheduled a job to shrink the TRANS

table residing on the TT tablespace. The job would run at 5:00 p.m. e

very Friday. When you examine the space usage of the table after the

completion of the job, you find that the table has not been shrunk. W

hat could have b een the reason for this?

A. The tablespace that contains the TRANS table is online.

B. The tablespace that contains the TRANS table is permanent.

C. The tablespace that contains the TRANS table is locally managed.

D. The segment space management of the tablespace that contains the T

RANS table is manual in nature.

Answer: D

Improved performance and space utilization

• Indexes maintained

• Triggers not executed

• Number of migrated rows may be reduced

• Rebuilding secondary indexes on IOTs

recommended

1、表必须启用row movement

2、表段所在表空间的段空间管理(segment space management)必须为auto
assm 和mssm
assm就设置个pctfree就行了。mssm就不一样。需要设置很多东西。

ITPub博客

043-058