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 |