053-009

9.Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure
for LOB space usage?
A. It returns space usage of only BasicFile LOB chunks.
B. It returns space usage of only SecureFile LOB chunks.
C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned
tables.
Answer: B

解析:
The existing SPACE_USAGE procedure is overloaded to return information about LOB space usage. It returns the amount of disk space in blocks used by all the LOBs in the LOB segment. This procedure can only be used on tablespaces that are created with auto segment space management.This procedure is for SECUREFILE LOBs.
http://docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_smart.htm#sthref162

posted @ 2014-04-20 08:59  bowshy  阅读(205)  评论(0)  编辑  收藏  举报