ORACLE 8i 遇到报错：ORA

最近在客户的一个8i生产库上使用statspack，发现alert中有报错： Mon Jun 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

最近在客户的一个8i生产库上使用statspack，发现alert中有报错：

WebService 四种发布方式总结 中文WORD版

本文档主要讲述的是WebService 四种发布方式总结；CXF与spring搭建webservice是目前最流行的方式，但是传闻cxf与jdk1.5有些不兼容，我没有遇到过，我遇到的问题是cxf与was6.1.1不兼容，表现在cxf必须的jar包“wsdl4j-1.6.2.jar”报错，报的错为： java.lang.IncompatibleClassChangeError，明显的jar包不兼容问题，很是头痛，后来查找资料找到解决办法是，将上述jar包新建一个wa

0

查看详情

Mon Jun 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 Jun 16 13:47:46 2014
 ORA-1631: max # extents 505 reached in table PERFSTAT.STATS$SQL_SUMMARY

解决如下：

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