Database Tuning (MOSC)

MOSC Banner

How to archive the history record of EBS table

edited Oct 18, 2012 8:00AM in Database Tuning (MOSC) 2 commentsAnswered ✓
Cusotmer used EBS based on Oracle database for more than 7 years,and some of tables have  hundred million records.  performance is a problem now ,such as, it's take serveral days to collect statics of the big table.

 From the database level , partiioning maybe a option but customer don't know if it works for pation of the big tables ,while left more non-partion tables which have complex relation with big tables.

Also , customer know the purge function in EBS, but it not so convient because the record will be accessed some times.

 They want the history records stay in the database ,but can move to low speed storage.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center