My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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
Goal
Solution
References


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