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

• Snippet:2021-3-5 11:44
  • [ORA-1652: unable to extend temp segment by 128 in tablespace xxx](https://stackoverflow
    .com/questions/25350703/ora-01652-unable-to-extend-temp-segment-by-128-in-tablespace-system-how-to-ext)
  • 问题概述：ORA-1652: unable to extend temp segment by 128 in tablespace xxx
  • 方案细节

      txt> 表空间满了,没有开启自动拓展.
      sql>
           select tablespace_name,file_name,autoextensible from dba_data_files where tablespace_name='TESTJIAMI';
      txt> 文件大小限制.
      sql>
           select value from v$parameter where name = 'db_block_size';
           Block Sz   Max Datafile Sz (Gb)   Max DB Sz (Tb)
           --------   --------------------   --------------
             2,048                  8,192          524,264
             4,096                 16,384        1,048,528
             8,192                 32,768        2,097,056
            16,384                 65,536        4,194,112
            32,768                131,072        8,388,224
      txt> 统计数据文件大小.
      sql> select bytes / 1024 / 1024 as mb_size
                , maxbytes / 1024 / 1024 as maxsize_set
                , x.*
             from dba_data_files x;
      txt> 解除数据文件最大限制.
           ALTER DATABASE DATAFILE '+DATA/ORCL/DATAFILE/testjiami' AUTOEXTEND ON MAXSIZE 3840M;
      info> 原任务未继续执行,下面通过获取awr报告分析.