Demantra Solutions - EBS (MOSC)

MOSC Banner

Initial Data Load into Oracle Database 11g is really slow! Help please send ideas to speed it up!

edited Sep 3, 2009 8:11PM in Demantra Solutions - EBS (MOSC) 3 commentsAnswered
 Current situation:  Just started loading for the first time an 11g database with data for a Demantra (version 7.2.0.1) and it is really taking a long time.
Background:
Demantra Version:  7.2.0.1
Database:  Oracle 11g
Hardware:  Linux

Data:  Weekly Buckets
Initial data load thus far is:  1 Customer
Items Per Store:                 180 items per store
Number of Stores:               8,462
History loading:                   2 years

What we are experiencing thus far is it is taking about:  7.5 hours to load one week with all customer store/item data.

Questions:

What should it take normally given this background on data load take?

What are some things I can have my technical team look into?

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

EBS Demantra Tags

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