OLT session report generation fail with ORA-01652 unable to extend temp segment by 128 in tablespace TEMP (Doc ID 2666209.1)

Last updated on FEBRUARY 27, 2023

Applies to:

Symptoms

Unable to generate reports. The report generator displays data, but does not complete.

wls_oats.log
--------------------

2020-04-21 00:49:42,406 DEBUG [SessionReportPool] Session Report Key Generated: 182.20.2_BT20213_Reliability_18Apr2020.NoThinkTime.TimeFilterActive=false.en
2020-04-21 00:49:42,608 ERROR [Query] Query: Name: detail.last
Rule: null
Col names:
SQL: FileName: report_performance_stats.xml
Name: detail.last
EngineConfig: oracle.oats.reports.EngineConfig@6748d2d0

Parameter: sessionName=20.2_BT20213_Reliability_18Apr2020 (-1)
Parameter: thinkTime=false (-1)
Parameter: counterName=Avg Server Time (sec)% (0)
Parameter: col=2 (0)
Parameter: timeFilterActive=false (0)
Parameter: currentLocalTimestamp=2020/04/21 00:37:44 (0)
Parameter: scriptLevelOnly=false (0)
Parameter: database=oracle (0)

There are 8 parameters
[1]: Parameter: sessionName=20.2_BT20213_Reliability_18Apr2020 (-1)
[2]: Parameter: thinkTime=false (-1)
[3]: Parameter: counterName=Avg Server Time (sec)% (0)
[4]: Parameter: col=2 (0)
[5]: Parameter: timeFilterActive=false (0)
[6]: Parameter: currentLocalTimestamp=2020/04/21 00:37:44 (0)
[7]: Parameter: scriptLevelOnly=false (0)
[8]: Parameter: database=oracle (0)

2020-04-21 00:49:42,611 ERROR [ReportException]
java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

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.