How is the space recovered by Oracle for deleted incidents?
Last Updated June 21, 2014
You want to purge and recover space from the data files that are already full.
Relevant versions: ALL
When you delete an incident, Vontu will mark it for deletion within the DB and Vontu will purge it during the scheduled purge (usually midnight). After the data is purged, Oracle will reuse the space for new incidents.
To clarify, Oracle will not surrender space that has been explicitly allocated to it. With the deletion and subsequent purge of incidents through Vontu, individual records are deleted from the database, but the database size will not shrink. The space released through deletion is re-used by new records and database growth is non-apparent until all useable "freed-blocks" are consumed.
NOTE: An issue with purging existed in v7.x
If you see an ORA-002292 error in the tomcat logs, you will need to apply this hotfix: FKey_Purge_PROTECT-6788-hotfix.zip (E-Track 1309990)