Why Is Price Book Consuming Massive Amounts of Undo and Temp Tablespace?
Last updated on MAY 03, 2017
Applies to:Oracle Advanced Pricing - Version 12.1 and later
Information in this document applies to any platform.
Question 1: For what does the Price Book functionality use the TEMP and UNDO Tablespaces?
Question 2: What information is the Price Book inserting into these Tablespaces?
Question 3: From which Tables do these Inserts read information come from?
Question 4: Why does the Price Book generate such an immense amount of data into those Tablespaces?
Question 5: What is Oracle's estimation for generating an All Items Price Book for 250k Items in terms of Time and Data Generated into those Tablespaces?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms