About oracle Archive Log

Avatar

Avatar
Validate 1
Level 1
daehob42316144
Level 1

Like

1 like

Total Posts

16 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
daehob42316144
Level 1

Like

1 like

Total Posts

16 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
daehob42316144
Level 1

15-05-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

982 likes

Total Posts

1,097 posts

Correct reply

517 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

982 likes

Total Posts

1,097 posts

Correct reply

517 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

16-05-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

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
daehob42316144
Level 1

Like

1 like

Total Posts

16 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
daehob42316144
Level 1

Like

1 like

Total Posts

16 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
daehob42316144
Level 1

16-05-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