Data Loss Prevention

Hi,

I have been deleteting incidents off enforce to clear up space on our single tier server that has the DB installed on the same server as enforce. While in the next few months we will be moving to a multi-tiered enviornment, I have a production issue where I have no disk space on my D drive where Oracle and DLP is installed, as Oracle is taking all the space up and causing incidents to queue up in Enforce. I have been deleting incidents off enforce but disk space does not let up. I tried running disk cleanup util, no memory dump files to delete, all the space is for the Oracle DB. How can I free up the white space after incidents are deleted off enforce. I am in a pinch here any suggestions will help as production is currently affected....

I already spoke with support they suggested to keep deleting incidents but the oracle db will eventually release the space. I am on a time crunch and eventually will not work for me....

Thanks

Oracle is designed for high performance, and Oracle does not clean up as rows are added and deleted, thus leaving a honeycomb of free space within the physical data blocks. 

Especially with DLP, most of the space utilization is as  BLOB (Binary Large Object).

In other words, after deleting incidents - you would start seeing free space in DLP UI.. System > Database > Table Summary. However the actual database file size would still remain unshrinked.

The only way, I've seen the file shrink especially for BLOB data is by performing a complete DB Export Import exercise. General information on this task overall:

http://www.dba-oracle.com/art_tuning_objects.htm

Hope this helps!

Hi  rodrige3,

Attached document will help you to reclaiming space in the Database.

Regards,

Ajeet

Attachment(s)

Reclaiming space in the Symantec Data Loss Database_1.pdf   238 KB 1 version