True statement regarding space management is:
In a locally managed tablespace free space are managed by bitmap
Coalescing of free space is not required in a locally managed tablespace
n.b.: Coalescing free space is not necessary for locally managed tablespaces, because bitmaps automatically track adjacent free space.
But free space in a dictionary managed tablespace can become fragmented, making it difficult to allocate new extents. For this way coalescing of free space is needed in a dictionary managed tablespace.
SQL > ALTER TABLESPACE tabsp_4 COALESCE;
Coalescing operation reduces one of the index partitions, which are partitioned using hash method. This method redistributes the index entries of an indexed partition.
SQL > ALTER INDEX parts1_hgidx COALESCE PARTITION PARALLEL
Monday, June 30, 2008
How to convert MP3 to Text
Download https://github.com/BtbN/FFmpeg-Builds/releases Convert to pure MP3 first & then Split (chatgpt) If the original f...
-
How to create Matrix report / Pivot Report using Oracle BI Publisher Step by step instruction: 1. Make data model using Oracle Reports Dev...
-
ORACLE BI PUBLISHER A. Please learn the steps of creating Matrix report from previous video B. Now we will discuss about Position, Sorting...
-
TO DECLARE/SET A VARIABLE VALUE: ------------------------------- <?xdoxslt:set_variable($_XDOCTX, 'variable name', value)?> ...