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

Last updated on MAY 03, 2017

Applies to:

Oracle Advanced Pricing - Version 12.1 and later
Information in this document applies to any platform.
qp_npreq_ldets_tmp

Goal

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?
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms