RE: gather_schema_stats failed with ORA-07445 ?
Date: Wed, 17 Sep 2008 19:23:08 +0530
Message-ID: <909E7530CE938B459169E41B32588907034796@HYDEXC07.kanbay.com>
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