3 Replies Latest reply on Aug 9, 2010 4:41 PM by 618702

    ORA - 12801 and ORA - 01652 ?

    645300
      Hello gurus,

      I was running a query on Oracle 11g RAC. One of the table has about 7 billions records

      Here is the error i got
       
      
      ORA-12801: error signaled in parallel query server 
      ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
      Any idea, what could be wrong ??


      Thank you!! Appriciate it !!
        • 1. Re: ORA - 12801 and ORA - 01652 ?
          sb92075
          01652, 00000, "unable to extend temp segment by %s in tablespace %s"
          // *Cause:  Failed to allocate an extent of the required number of blocks for
          //          a temporary segment in the tablespace indicated.
          // *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
          //          files to the tablespace indicated.
          increase size of TEMP tablespace
          • 2. Re: ORA - 12801 and ORA - 01652 ?
            618702
            Dear user642297,

            In order to get rid of that error, you need to increase the temporary tablespace called TEMP and i think it is the default one for your situation.

            You can also check below link;

            http://www.dba-oracle.com/t_ora_12801_parallel_query.htm

            But there is a comment that says increase the sort_area_size, don't do that since you are running on 11g. Instead of that parameter, increase or decrease the PGA_AGGREGATE_TARGET.

            Hope That Helps.

            Ogan
            • 3. Re: ORA - 12801 and ORA - 01652 ?
              618702
              Dear user642297,

              In order to get rid of that error, you need to increase the temporary tablespace called TEMP and i think it is the default one for your situation.

              You can also check below link;

              http://www.dba-oracle.com/t_ora_12801_parallel_query.htm

              But there is a comment that says increase the sort_area_size, don't do that since you are running on 11g. Instead of that parameter, increase or decrease the PGA_AGGREGATE_TARGET.

              Hope That Helps.

              Ogan