Expand my Community achievements bar.

SOLVED

About oracle Archive Log

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

Create tablespaces without logging for the temp tables, then add them in ACC under Administration/Platform/Options:

  • WdbcOptions_TableSpaceWork: work tables with no schema
  • WdbcOptions_TableSpaceWorkIndex: index of work tables with no schema

Thanks,

-Jon

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi,

Create tablespaces without logging for the temp tables, then add them in ACC under Administration/Platform/Options:

  • WdbcOptions_TableSpaceWork: work tables with no schema
  • WdbcOptions_TableSpaceWorkIndex: index of work tables with no schema

Thanks,

-Jon

Avatar

Level 2

Hi wondnicki,

Thanks for your response.

As per your response, In this case I think these options have to configured by oracle temporary table space name.

I think when we created database, we didn't configure that options.

So now, that options are empty and I think work tables data or logs stored in default table space or system table space.

Your answer is very helpful for us.

I think we need to reconfigure ACC database.

Thanks,

Best Regards,

Daeho