ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-058

043-058

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-06 11:01:00 0 删除 编辑
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博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-717821/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 043-057
下一篇: 043-058
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    214031