ORA-1652: unable to extend temp segment by 128 in tablespace TEMP

Reference Note 748251.1

Possible Cause 

ISSUE IS LIKELY CAUSED BY 

Bug 5689290 - VIEW V$RMAN_BACKUP_JOB_DETAILS SLOW CAUSING DATABASE CONSOLE LOGIN TIMEOUTS

which identified an issue with excessive temp space usage by emagent.

Bug 5689290 was closed as a duplicate of

Bug 5466436 - VIEW V$RMAN_BACKUP_JOB_DETAILS SLOW CAUSING DATABASE CONSOLE LOGIN TIMEOUTS

which was subsequently closed as a duplicate of:

Bug 8434467 - SLOW PERFORMANCE FOR QUERY ON V$RMAN_BACKUP_JOB_DETAILS

Solution

1.  Upgrade to any fixed version, e.g.

12.1 (Future Release)

11.2.0.2 (Server Patch Set)

11.2.0.1 Patch 4 on Windows Platforms

11.1.0.7 Patch 37 on Windows Platforms

10.2.0.5 Patch 4 on Windows Platforms

10.2.0.4 Patch 41 on Windows Platforms

- OR -

2. Apply Patch 8434467 as available for the your actual platform and Oracle version.

- OR -

3. Use the following workaround to reduce the temp usage by emagent / dbsnmp:

exec dbms_stats.DELETE_TABLE_STATS('SYS','X$KCCRSR'); ==> deletes the statistics on the fixed object

exec dbms_stats.LOCK_TABLE_STATS('SYS','X$KCCRSR'); ==> lock that object so that statistics will not be collected in future

alter system flush shared_pool;  ==> cannot be skipped