Resolution of ORA-01631 errors in ORACLE 8i

Recently used Statspack on a customer's 8i production library and found an error in alert:

Mon June 16 13:17:52 2014

Errors in FILE/ORACLE/8.1.7/ADMIN/PROD/BDUMP/SNP0_96626_PROD.TRC:

Ora-12012:error on Auto execute of Job 304

Ora-01631:max # Extents (505) reached in table Perfstat. Stats$sql_summary

Ora-06512:at "Perfstat. Statspack ", line 978

Ora-06512:at "Perfstat. Statspack ", line 1612

Ora-06512:at "Perfstat. Statspack ", line 71

Ora-06512:at Line 1

Mon June 16 13:47:46 2014

Ora-1631:max # Extents 505 reached in table Perfstat. Stats$sql_summary

Resolved as follows:

Sql> Select tablespace_name,bytes/1024/1024 from Dba_free_space where tablespace_name= ' STATSPACK1 ';

Tablespace_name bytes/1024/1024

------------------------------ ---------------

STATSPACK1 63.484375

STATSPACK1 2047.99219

Sql> SELECT Segment_name, owner, extents, Max_extents,segment_type

2 from Dba_segments

3 WHERE segment_name = ' stats$sql_summary ';

Segment_name OWNER Extents Max_extents

-------------------- ------------------------------ ---------- -----------

Segment_type

------------------

Stats$sql_summary Perfstat 505 505

TABLE

sql> ALTER table Perfstat. Stats$sql_summary STORAGE (maxextents 8192);

Table altered.

Sql> Set Linesize 1000

Sql> SELECT Segment_name, owner, extents, Max_extents,segment_type

2 from Dba_segments

3 WHERE segment_name = ' stats$sql_summary ';

Segment_name OWNER Extents max_extents segment_type

-------------------- ------------------------------ ---------- ----------- ------------------

Stats$sql_summary Perfstat 505 8192 TABLE

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/