Extract Generating huge trail files due to JAI_TAX_DET_FACTORS table

[kvmishra]

Hello Sir,

We are extracting before/after image of certain tables from Oracle EBS database using OGG in XML trail files  and collecting data in AVDF. We observed that there is a single table JAI_TAX_DET_FACTORS which is generating huge volumn for trail files around 80-100GB per day. Could you please help me to identify whether this usual or not even from EBS side?

We have created a seprate extract for the table as below:
EXTRACT EXT4
USERIDALIAS ggadminCDB DOMAIN OracleGoldenGate
OUTPUTFORMAT XML _AUDIT_VAULT
EXTTRAIL audit_trail/EXT4/tr
SOURCECATALOG E110P
IGNOREINSERTS
TABLE JA.JAI_TAX_DET_FACTORS , KEYCOLS (ENTITY_CODE,TRX_NUMBER,TRX_LINE_NUMBER,DET_FACTOR_ID);

Due to huge volumn of data, AVDF collection is lagging and storage is also getting full. If this will go as it is, it will be a mess to have that much storage in next few years.

Thanks in Advance.

[ErmanArslansOracleBlog]

That table is related with Oracle India Localization.
It is definitely not usual for a single table like JAI_TAX_DET_FACTORS to generate 80–100GB of trail files daily.

Check that table with queries and try to understand the update frequency? Speak with your functional admins..

btw, you are sending this to Audit Vault and Database Firewall (AVDF). Do you really need every single column for auditing purposes.. Check that and eliminate some of the overhead from there..

Also consider tuning OGG config for dealing with that kind of a load.