Using Oracle dbms_space
Use the Oracle procedure
dbms_space.space_usage to provide the space
usage ratio within each block in the Bitmap
Managed Block (BMB) segments. It provides
information regarding the number of blocks
in a segment with the following range of
free space.
Oracle9i provides several new procedures for
automated space management. These include:
-
dbms_space.space_usage
-
dbms_repair.rebuild_freelists
-
Querying the DBA_TABLES view
The most
important procedure in the dbms_space
package is the space_usage procedure. As you
may recall, you can get information directly
from DBA_TABLES on block usage.
Locally
managed tablespaces (LMT) and automatic
segment space management (ASSM) provide a
new way to manage freelists for individual
objects in a database. Along with these ASSM
features, Oracle9i provides several new DBMS
PL/SQL packages for viewing and managing
tablespaces with ASSM. These include:
dbms_space.space_usage
dbms_repair.rebuild_freelists
Use the new
dbms_space.space_usage procedure for
reporting the space position in BMB
segments. This procedure provides the space
usage ratio within each block. It is
preferred over the dbms_space.free_blocks
procedure.
Use the
Oracle procedure dbms_space.space_usage to
provide the space usage ratio within each
block in the Bitmap Managed Block (BMB)
segments.
|
|
