(Oracle databases only) Complete the following tasks
to minimize storage consumption in the Event table:
- Determine the typical size of the serialized_source_object and
the serialized_orig_object columns.
select dbms_lob.getlength(serialized_source_object) from event
- 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.