时间:2021-07-01 10:21:17 帮助过:36人阅读
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
ORACLE 8i 遇到报错:ORA-01631: max # extents (505) reached in table
标签:admin auto type error sum rod lte each 使用