After converting the DLP lob_tablespace files to SecureFile, there is no shrinking of the size of the files.
Article ID: 191841
Updated On:
Products
Issue/Introduction
We require DLP's LOB_TABLESPACE to be in SecureFile (see Converting your LOB tables from BasicFiles to SecureFiles format) for all DLP versions after 15.5.
One of the features explained was better reclamation of the space.
This creates confusion since the Symantec Reclamation tool was previously used to reclaim space in the database.
Environment
Symantec Data Loss Prevention (DLP)
Data Loss Prevention Oracle Standard Edition 2
Cause
Oracle's Automatic Segment Space Management (ASSM) is designed for efficiency in the database, meant for reuse and speed.
Oracle space management is not designed to redo the size of the files once it has been allocated.
Deleting incidents allows SecureFile to reuse the space in a more efficient manner, it does not empty the space. Since it does not empty the space, it will not show files shrinking.
Resolution
SecureFile provides performance improvements to our LOB storage by utilizing Oracle's Automatic Space Management (ASSM).
- SecureFile tracks deleted LOBs and makes that space available for Oracle to reuse after the retention period expires.
- After converting to SecureFile LOB storage, you do not need to run a script to "reclaim" LOB space in your database.
- SecureFile will re-purpose deleted LOB space for Oracle to use automatically so that space is no longer unusable unlike BasicFile LOB management.
If SecureFile spent the time required to resize the files, that is time it wastes not able to process requests.
Additional Information
Beginning with Oracle Database 12c, SecureFiles LOB storage became the default in the CREATE TABLE statement. If no storage type is explicitly specified, new LOB columns use SecureFiles LOB storage.
You may also want to review:
Why doesn't the database shrink after incidents are deleted?
Converting your LOB tables from BasicFiles to SecureFiles format in Symantec DLP
Oracle tablespace (LOB_TABLESPACE, USERS, etc.) for DLP is full, almost full, or critically full
Feedback
