IBM FileNet P8, Version 5.2.1            

Reducing auditing database space consumption

(Oracle databases only) Complete the following tasks to minimize storage consumption in the Event table:

  1. Determine the typical size of the serialized_source_object and the serialized_orig_object columns.
    select dbms_lob.getlength(serialized_source_object) from event
  2. Place the LOB data into a table space that has a block size chosen appropriately as follows:
    • Choose a minimum block size that will store the value. (If the LOB size is less than 4 KB, LOB data will be stored in rows by default.)
    • Set the CHUNK size to the same as the block size.
    • Set PCTVersion to 0. (Because events are never updated, setting PCTVersion to 0 helps to save space.


Last updated: March 2016
p8ppt186.htm

© Copyright IBM Corporation 2016.