10.3 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 Database 23ai.