My Oracle Support Banner

How to manage the growth of the table QP.QP_DOCUMENTS (Doc ID 1501323.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Advanced Pricing - Version 12 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Goal

 Lob segment for table QP.QP_DOCUMENTS grows fast.

Lob segment for table QP.QP_DOCUMENTS grows fast and has big size over 60Gb.

OWNER SEGMENT_NAME SEGMENT_TYPE BEGIN_DA END_DATE B_COL E_COL GROWTH
------------------- -------------------------------------- --------------- -------- -------- ---------- ---------- ----------
QP SYS_LOB0000247674C00010$$ LOBSEGMENT 10/07/12 10/14/12 60237 61069


1. Why is the table growing?
2. How can the table be managed?

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.