V$SECUREFILE_SHRINK

V$SECUREFILE_SHRINK displays information about SecureFiles Shrink tasks.

Column Datatype Description
LOB_OBJD NUMBER Database object number for the LOB segment
SHRINK_STATUS VARCHAR2(40)

Status of the shrink task:

  • RUNNING

  • COMPLETE

  • ERROR
START_TIME TIMESTAMP(3) WITH TIME ZONE Date and time at which the shrink task started
END_TIME TIMESTAMP(3) WITH TIME ZONE

Data and time at which the shrink task ended

If SHRINK_STATUS = RUNNING, the value of this column is NULL.

BLOCKS_MOVED NUMBER Number of blocks relocated during the shrink task
BLOCKS_FREED NUMBER Number of blocks freed during the shrink task
BLOCKS_ALLOCATED NUMBER

Number of blocks allocated from the tablespace during the shrink task

This value includes only blocks allocated by the shrink process. Blocks allocated by other database processes are not included.
EXTENTS_ALLOCATED NUMBER

Number of extents allocated from the tablespace during the shrink task

This value includes only extents allocated by the shrink process. Extents allocated by other database processes are not included.
EXTENTS_FREED NUMBER Number of extents freed during the shrink task
EXTENTS_SEALED NUMBER Number of candidate extents selected and sealed during the shrink task
AUTOMATIC NUMBER Indicates whether the shrink task was started automatically (1) or manually (0)
CON_ID NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Note: This view is available starting with Oracle AI Database 26ai.