RE: gather_schema_stats failed with ORA-07445 ?

From: Harshan Vasudevan Eppurath <harshan.eppurath_at_capgemini.com>
Date: Wed, 17 Sep 2008 19:23:08 +0530
Message-ID: <909E7530CE938B459169E41B32588907034796@HYDEXC07.kanbay.com>

gather_schema_stats failed with ORA-07445 ?



An ORA-03113 end-of-file on communication channel error is a very generic error that indicates that the connection has been lost. Since it show ORA-7445 on alert log you may need to contact Oracle support.
 


From: oracle-l-bounce@freelists.org on behalf of Guang Mei
Sent: Wed 9/17/2008 7:00 PM
To: oracle-l-freelists
Subject: gather_schema_stats failed with ORA-07445 ?

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:    &nbs p; 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@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
57 844cbf0     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  & nbsp;  point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+744         CALL     ksedst()             000000840 ?
                                                   FFFFFFFF7FFEC9AC ?
                                           &nbs p;       000000000 ?
                                                   FFFFFFFF7FFE94A0 ?
                                                   FFFFFFFF7FFE8208 ?
                                                & nbsp;  FFFFFFFF7FFE8C08 ?
ssexhd()+1000        CALL     ksedmp()             000106000 ? 106323304 ?
                                                   106323000 ? 000106323 ?
                                                   000106000 ? 106323304 ?
sigacthandler()+44   PTR_CALL 0000000000000000     000380007 ?
 &nbs p;                                                 FFFFFFFF7FFF05F0 ?
                                                   000000067 ? 000380000 ?
                                                   00000000B ? 106323300 ?
smboAQSdoRS()+336&nb sp;   PTR_CALL 0000000000000000     00000000B ?
                                                   FFFFFFFF7FFF05F0 ?
                                                   FFFFFFFF7FFF0310 ?
                                           &nbs p;       00000000B ? 000000001 ?
                                                   000000008 ?
...


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


-- http://www.freelists.org/webpage/oracle-l Received on Wed Sep 17 2008 - 08:53:08 CDT

Original text of this message