Recently used Statspack on a customer's 8i production library. 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
The solutions are for example the following:
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 Perfstat505 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
ORACLE 8i encountered error: Ora-01631:max # extents (505) reached in table