My Oracle Support Banner

Need To Archive Heavy Tables (file Size In GB) To Speed Up The ECM Batch Which Is 1 Month Behind. (Doc ID 2909889.1)

Last updated on NOVEMBER 22, 2022

Applies to:

Oracle Financial Services Enterprise Case Management - Version 8.0.7 and later
Information in this document applies to any platform.

Goal

Problem Summary
---------------------------------------------------
Need to archive heavy tables (file size in GB) to speed up the ECM batch which is 1 month behind.

Problem Description
---------------------------------------------------
1. The client batch run is behind 1 month and is taking a lot of time. We have identified top 20 heavy tables which needs to be archived. We need to know how this can be done so we can cover up the delayed batch run as it is taking significantly a lot of time.

2. Can you please explain that is it a normal behaviour that the size of the tables are up to 90GB with the data of only 6months?

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.