My Oracle Support Banner

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 JUNE 17, 2022

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.
FASRSVES.rdf: Reserve Summary Report
FASRSVED.rdf: Reserve Detail Report
RXFAPOGT: Populate Balance Report GT Data
FACOSTS.rdf Cost Summary Report
FASCOSTD.rdf Cost Detail Report


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;

'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;


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..





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
 Still Have Questions?

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