Details: SecureFiles Defragmentation
This page provides more detailed information about defragmentation operations on SecureFiles.
A new view, V$SECUREFILE_SHRINK
, reports the results of the defragment operations. A new row is created after each invocation of shrink and is continuously updated. After the shrink is done, the row remains static, and a new invocation of shrink for the same segment overwrites the row.