HI all,
I have one question about ACC with Oracle.
When we try to make complex workflow, there are some issues which are related with oracle archive log.
Sometimes, we use many enrichment activity in workflow.
At that time, if we want to query large scale customer information, each enrichment activity will make many temporary tables.
And when ACC make temporary tables, it will make too many oracle archive log.
Sometime this can make very serious problem (like DB space lack).
Because of this issues, our client want to use oracle 'append' hint.
But as I know, we can not control factory configured query.
So I think we need to focus oracle 'nologging' option on table level.
Are there any option which is related with oracle 'nologging' option in ACC?
Or if you have experienced about ACC with Oracle, could you please let me know your experience ?
FYI. Due to customer's internal policy, We can not turn off oracle archive log. And we can not control archived log retention period.
Thanks,
Best Regards,
Daeho