My Oracle Support Banner

Why Is Price Book Consuming Massive Amounts of Undo and Temp Tablespace? (Doc ID 2116959.1)

Last updated on MAY 19, 2020

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?


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

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