Oracle OCP 1Z0 053 Q96(Shrink Space Compact)
96.Examine the following command:
SQL> ALTER TABLE booking SHRINK SPACE COMPACT;
Which activity is performed when the preceding command is executed?
A. The shrink operation touches every block in the BOOKING table
B. The high-water mark (HWM) for the BOOKING table is shifted from its original position
C. The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
D. The data manipulation language (DML) triggers on the BOOKING table are executed because the
shrink operation is internally handled by the INSERT/DELETE operation
Answer: C
compact不会做释放高水位的动作
如果有长时间运行的查询，而且这些查询可能跨越收缩操作，并尝试从已回收的块中读取数据，则COMPACT子句会很有用。指定SHRINK SPACE COMPACT子句时，收缩操作的进度将保存在相应段的位图块中。这意味着下次在同一个段上执行收缩操作时，Oracle DB Server 可以记住已经执行过的操作。然后你就可以在非峰值时段重新发出SHRINK SPACE子句，无需使用COMPACT子句即可完成第二阶段
参考：http://blog.csdn.net/jgmydsai/article/details/37350269
http://blog.csdn.net/rlhua/article/details/13431595
SQL> ALTER TABLE booking SHRINK SPACE COMPACT;
Which activity is performed when the preceding command is executed?
A. The shrink operation touches every block in the BOOKING table
B. The high-water mark (HWM) for the BOOKING table is shifted from its original position
C. The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
D. The data manipulation language (DML) triggers on the BOOKING table are executed because the
shrink operation is internally handled by the INSERT/DELETE operation
Answer: C
compact不会做释放高水位的动作
如果有长时间运行的查询，而且这些查询可能跨越收缩操作，并尝试从已回收的块中读取数据，则COMPACT子句会很有用。指定SHRINK SPACE COMPACT子句时，收缩操作的进度将保存在相应段的位图块中。这意味着下次在同一个段上执行收缩操作时，Oracle DB Server 可以记住已经执行过的操作。然后你就可以在非峰值时段重新发出SHRINK SPACE子句，无需使用COMPACT子句即可完成第二阶段
参考：http://blog.csdn.net/jgmydsai/article/details/37350269
http://blog.csdn.net/rlhua/article/details/13431595
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-2073842/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
