gather_schema_stats failed with ORA-07445 ?

From: Guang Mei <guangmei_at_yahoo.com>
Date: Wed, 17 Sep 2008 06:30:01 -0700 (PDT)
Message-ID: <973432.8016.qm@web39508.mail.mud.yahoo.com>

Oracle 10.2.0.1 on Sun Solaris.

My daily stats gathering on a schema usually works, but it fails occasionally (maybe once a month). Last night it failed again with the following:

BEGIN sys.dbms_stats.gather_schema_stats('MY_SCHEMA',5, cascade=>TRUE); END;

*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

ERROR:
ORA-03114: not connected to ORACLE

I looked alert log and dump file. The dump file has this info below. Has anyone seen this? I searched Metalink/Google and found nothing. Any idea why the stats gathering failed?

Thanks.
Guang

bash-2.03$ more es_dw_ora_29858.trc
/opt/oracle/admin/ES_DW/udump/es_dw_ora_29858.trc Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options ORACLE_HOME = /opt/oracle/product/10.2.0 System name: SunOS

Node name:      armstrong
Release:        5.8
Version:        Generic_117350-53
Machine:        sun4u

Instance name: ES_DW
Redo thread mounted by this instance: 1
Oracle process number: 36
Unix process pid: 29858, image: oracle_at_armstrong (TNS V1-V3)

• 2008-08-25 07:30:38.421
• ACTION NAME:() 2008-08-25 07:30:38.396
• MODULE NAME:(SQL*Plus) 2008-08-25 07:30:38.396
• SERVICE NAME:(SYS$USERS) 2008-08-25 07:30:38.396
• SESSION ID:(224.26215) 2008-08-25 07:30:38.396 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x 2e31373505391a36, PC: [0x1009ffaf0, smboAQSdoRS()+336]
• 2008-08-25 07:30:38.461 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [smboAQSdoRS()+336] [SIGSEGV] [Addre ss not mapped to object] [0x2E31373505391A36] [] [] Current SQL statement for this session: select min(minbkt),maxbkt,substrb(dump(min(val),16,0,32),1,120) minval,substrb(d ump(max(val),16,0,32),1,120) maxval,sum(rep) sumrep, sum(repsq) sumrepsq, max(re p) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from ( select val,min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(va l) repsq from (select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_ sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */"MEMBERID" val, ntile(254) over (order by "MEMBERID") bkt from sys.ora_temp_1_ds_75749 t w here "MEMBERID" is not null) group by val) group by maxbkt order by maxbkt ----- PL/SQL Call Stack ----- object line object handle number name 57844cbf0 11222 package body SYS.DBMS_STATS 57844cbf0 11504 package body SYS.DBMS_STATS 57844cbf0 12107 package body SYS.DBMS_STATS 57844cbf0 12518 package body SYS.DBMS_STATS 57844cbf0 12964 package body SYS.DBMS_STATS 57844cbf0 13165 package body SYS.DBMS_STATS 57844cbf0 13556 package body SYS.DBMS_STATS 57844cbf0 13634 package body SYS.DBMS_STATS 57844cbf0 13593 package body SYS.DBMS_STATS 574a34640 1 anonymous block ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedmp()+744 CALL ksedst() 000000840 ? FFFFFFFF7FFEC9AC ? 000000000 ? FFFFFFFF7FFE94A0 ? FFFFFFFF7FFE8208 ? FFFFFFFF7FFE8C08 ? ssexhd()+1000 CALL ksedmp() 000106000 ? 106323304 ? 106323000 ? 000106323 ? 000106000 ? 106323304 ? sigacthandler()+44 PTR_CALL 0000000000000000 000380007 ? FFFFFFFF7FFF05F0 ? 000000067 ? 000380000 ? 00000000B ? 106323300 ? smboAQSdoRS()+336 PTR_CALL 0000000000000000 00000000B ? FFFFFFFF7FFF05F0 ? FFFFFFFF7FFF0310 ? 00000000B ? 000000001 ? 000000008 ? ...

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 17 2008 - 08:30:01 CDT