Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Temp space problem

2670775Dec 15 2015 — edited Dec 21 2015

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/12.1.0/db_1
System name:    Linux
Node name:      servername
Release:        2.6.32-279.22.1.el6.x86_64
Version:        #1 SMP Tue Feb 5 14:33:39 CST 2013
Machine:        x86_64
Instance name: database
Redo thread mounted by this instance: 1
Oracle process number: 452
Unix process pid: 22614, image: oracle@server.egis.hksarg (J000)


*** 2015-12-15 22:39:54.115
*** SESSION ID:(85.1885) 2015-12-15 22:39:54.115
*** CLIENT ID:() 2015-12-15 22:39:54.115
*** SERVICE NAME:(SYS$USERS) 2015-12-15 22:39:54.115
*** MODULE NAME:(DBMS_SCHEDULER) 2015-12-15 22:39:54.115
*** ACTION NAME:(ORA$AT_OS_OPT_SY_19466) 2015-12-15 22:39:54.115

ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_19466"
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01
ORA-06512: at "SYS.DBMS_STATS", line 41887
ORA-06512: at "SYS.DBMS_STATS", line 42473
ORA-06512: at "SYS.DBMS_STATS", line 42678

May I know any problem on this ??

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2016
Added on Dec 15 2015
20 comments
4,124 views