ORA-25153 during gathering execution plan (Doc ID 1945271.1)

Last updated on DECEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 29-DEC-2016***

Symptoms

SQL> set autotrace traceonly;
SQL> SELECT CUST_ID, Count(*)
FROM sh.SALES
GROUP BY CUST_ID;
  2    3
7059 rows selected.


Execution Plan
----------------------------------------------------------
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-25153: Temporary Tablespace is Empty


SP2-0612: Error generating AUTOTRACE EXPLAIN report

Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
        548  consistent gets
          0  physical reads
          0  redo size
     154004  bytes sent via SQL*Net to client
       5721  bytes received via SQL*Net from client
        472  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
       7059  rows processed
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms