Demantra Solutions - EBS (MOSC)

MOSC Banner

Is Sales Data Table Reorganization sensitive to the number of records (rows) in the table?

edited Mar 14, 2013 10:14PM in Demantra Solutions - EBS (MOSC) 3 commentsAnswered
In a recent implementation we have about 80 million records on sales data.
Over the planning cycle we have seen that performance decreases as more users input information into demantra.
We have ran several times the sales data reorganization table following [ID 1085012.1]

This is my understanding of the sales_data reorganization process:

i.         Check for fragmentation (out of order ratio) 

ii.       Rebuild the data table and while rebuilding, reordering the columns so that columns with no data will be at the end of the table

iii.      Then import the data back based on the primary key

iv.     Confirm that table fragmentation (out of order ratio) has decreased 

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center