dbms_space_admin.ASSM_TABLESPACE_VERIFY
- From: "Dhimant Patel" <drp4kri@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Oct 2006 16:29:44 -0400
Hi All,
I couldn't figure out exactly how one can use TS_OPTION for the above
mentioned procedure.
What are the difference in functionality of each options?
Below is the description from oracle documentation. First option is clear
from the description, other two is ambiguous. I also noticed that a "note"
was intended for each option from (1),(2) and (3), but there is no such
notes present.
Any help appreciated -
TABLESPACE_VERIFY_BITMAPS: The bitmaps are verified against the extents.
This will detect bits that are marked used or free wrongly and will also
detect multiple allocation of extents. The file metadata will be validated
against file$ and control file. This is the default option (1).
TABLESPACE_VERIFY_DEEP: This option is used to verify the file bitmaps as
well perform checks on all the segments (2).
TABLESPACE_VERIFY_SEGMENTS: This option is used to invoke SEGMENT_VERIFY on
all the segments in the tablespace. Optionally the user can write a script
that queries all the segments in the tablespace and invoke SEGMENT_VERIFY(3).
Thanks,
Dhimant Patel.
Other related posts:
- » dbms_space_admin.ASSM_TABLESPACE_VERIFY
