About oracle Archive Log | Community
Skip to main content
D
daehob42316144
Level 2
May 16, 2019
Solved

About oracle Archive Log

  • May 16, 2019
  • 2 replies
  • 1739 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

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

2 replies

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
May 16, 2019

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

    D
    daehob42316144Author
    Level 2
    May 17, 2019

    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

    Terms & ConditionsAccessibility statement

    Loading footer...