R12.1 Reserve Summary/Detail Reports: Performance Issue: Populate Balance Report GT Data Request Hangs/Exhausts Temp Tablespace Errors With ORA-01652: unable to extend temp segment (Doc ID 1594295.1)

Last updated on JULY 30, 2024

Applies to:

Symptoms

The balances reports:

Reserve Summary Report (FASRSVES)

Reserve Detail Report (FASRSVED)

Cost Summary Report (FASCOSTS)

Cost Detail Report (FASCOSTD)

 are running for several hours, and consume large amounts of temporary tablespace, before the Populate Balance Report GT Data sub-requests exhaust all available Temp tablespace and end with the error;

Error
-----------------------
'ORA-01652: unable to extend temp segment by 16 in tablespace TEMP1'

The SQL statement starting as follows, can be seen as the most time-consuming one in the tkprof;

INSERT INTO FA_BALANCES_REPORTS_ITF......

The following profile options are already set, to try to optimize the performance;

FA: Batch Size 10000
FA: Number of Parallel Requests 10

This resolved Cost Summary and Cost Detail reports, run for the same parameters, but reserve reports persist..

Changes

Cause

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