Unusual problem
463579Dec 28 2006 — edited Dec 29 2006Hello! An unusual situation here:
Recently one of my clients reported a problem considering Oracle XE.
Database didin't work.
We restarted the server (Win 2000 SP4) and everything was working, BUT they can't save anything.
They have all data but when they try to post it throws :
ORA-03114 NOT CONECTED TO ORACLE
I looked at alert_xe.log
every time when the client tries to post a record:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kkbgenr+108] [PC:0x16710E8] [ADDR:0x2] [UNABLE_TO_WRITE] []
I look over the alert_xe.log, first error were
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kkbgenr+108] [PC:0x16710E8] [ADDR:0x2] [] []
and before that I found one more error
ORA-00313: open failed for members of log group 1 of thread 1
Below are trc files for this errors
Thank you for your help!
-------------------------------------------------------------------------------------------
Error
Tue Oct 03 16:48:31 2006
Errors in file d:\tetral\skojo\oracle\app\oracle\admin\xe\udump\xe_ora_3520.trc:
ORA-00313: open failed for members of log group 1 of thread 1
trc for this error
-------------------------------------------------------------------------------------------
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Windows 2000 Version V5.0 Service Pack 4
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:188M/511M, Ph+PgF:1007M/1397M, VA:1792M/2047M
Instance name: xe
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
Windows thread id: 3520, image: ORACLE.EXE (SHAD)
KCCDEBUG_LEVEL = 0
Running with 1 strand for Non-Enterprise Edition
Running without dynamic strand for Non-Enterprise Edition
Dynamic strand is set to FALSE
Running with 1 shared and 10 private strand(s). Zero-copy redo is FALSE
Dump file d:\tetral\skojo\oracle\app\oracle\admin\xe\udump\xe_ora_3520.trc
Tue Oct 03 16:48:29 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Windows 2000 Version V5.0 Service Pack 4
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:130M/511M, Ph+PgF:884M/1397M, VA:1748M/2047M
Instance name: xe
Redo thread mounted by this instance: 0 <none>
Oracle process number: 17
Windows thread id: 3520, image: ORACLE.EXE (SHAD)
*** SERVICE NAME:() 2006-10-03 16:48:29.125
*** SESSION ID:(39.1) 2006-10-03 16:48:29.125
kccsga_update_ckpt: num_1 = 8, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
Control file created with size 430 blocks
Prior to RESETLOGS processing...
ALTER SYSTEM ARCHIVE LOG ALL USING BACKUP CONTROLFILE start
Database is not in archivelog mode
ALTER SYSTEM ARCHIVE LOG ALL USING BACKUP CONTROLFILE complete
*** 2006-10-03 16:48:31.203
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00313: open failed for members of log group 3 of thread 1
*** 2006-10-03 16:48:50.093
krvscm(+): Validating controlfile with logical metadata
krvscm(+): Initial controlfile state
krvscm(+): kccdiflg [400000] kccdifl2 [1000]
krvscm(+): kccdi2ldscn [0x0000.00000000]
krvscm(+): kccdi2lrscn [0x0000.00000000]
krvscm(+): Inspecting logical metadata
krvscm(+): Metadata state
krvscm(+): hasPrepSwitchSta [0]
krvscm(+): hasPrepSwitchPri [0]
krvscm(+): hasReceivedDict [0]
krvscm(+): hasDumpedDict [0]
krvscm(+): hasCommittedBor [0]
krvscm(+): hasSwitchedFromPri [0]
krvscm(+): hasStartedTa [0]
krvscm(+): hasValidSess [0]
krvscm(+): hasTxnConsistency [0]
krvscm(+): hasCleanlyShutdown [0]
krvscm(+): Generating new controlfile state from metadata
krvscm(+): Updating controlfile with new state
krvscm(+): New controlfile state
krvscm(+): kccdiflg [400000] kccdifl2 [1000]
krvscm(+): kccdi2ldscn [0x0000.00000000]
krvscm(+): kccdi2lrscn [0x0000.00000000]
krvscm(+): Updating SGA associated with controlfile state
krvscm(+): Validation complete
-------------------------------------------------------------------------------------------
Error
Tue Dec 05 22:00:38 2006
Errors in file d:\tetral\skojo\oracle\app\oracle\admin\xe\bdump\xe_j000_2860.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kkbgenr+108] [PC:0x16710E8] [ADDR:0x2] [] []
trc for this error (short version)
-------------------------------------------------------------------------------------------
Dump file d:\tetral\skojo\oracle\app\oracle\admin\xe\bdump\xe_j000_2860.trc
Tue Dec 05 22:00:38 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Windows 2000 Version V5.0 Service Pack 4
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:66M/511M, Ph+PgF:705M/1246M, VA:1724M/2047M
Instance name: xe
Redo thread mounted by this instance: 1
Oracle process number: 18
Windows thread id: 2860, image: ORACLE.EXE (J000)
*** ACTION NAME:(GATHER_STATS_JOB) 2006-12-05 22:00:38.359
*** MODULE NAME:(DBMS_SCHEDULER) 2006-12-05 22:00:38.359
*** SERVICE NAME:(SYS$USERS) 2006-12-05 22:00:38.359
*** SESSION ID:(35.1288) 2006-12-05 22:00:38.359
*** 2006-12-05 22:00:38.359
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kkbgenr+108] [PC:0x16710E8] [ADDR:0x2] [UNABLE_TO_WRITE] []
Current SQL statement for this session:
select /*+ no_parallel_index(t,I_TABPART_BOPART$) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_expand index(t,"I_TABPART_BOPART$") */ count(*) as nrw,count(distinct sys_op_lbid(269,'L',t.rowid)) as nlb,null as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "SYS"."TABPART$" t where "BO#" is not null or "PART#" is not null
----- PL/SQL Call Stack -----
object line object
handle number name
1527FE50 9406 package body SYS.DBMS_STATS
1527FE50 9919 package body SYS.DBMS_STATS
1527FE50 10541 package body SYS.DBMS_STATS
1527FE50 13027 package body SYS.DBMS_STATS
1527FE50 18889 package body SYS.DBMS_STATS
----- Call Stack Trace -----
I cuted here ... its to long...
-------------------------------------------------------------------------------------------
Error
Tue Dec 05 22:01:02 2006
Errors in file d:\tetral\skojo\oracle\app\oracle\admin\xe\bdump\xe_cjq0_2452.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kkbgenr+108] [PC:0x16710E8] [ADDR:0x2] [UNABLE_TO_WRITE] []
trc for this error
-------------------------------------------------------------------------------------------
Dump file d:\tetral\skojo\oracle\app\oracle\admin\xe\bdump\xe_cjq0_2452.trc
Tue Dec 05 22:01:02 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Windows 2000 Version V5.0 Service Pack 4
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:64M/511M, Ph+PgF:712M/1246M, VA:1730M/2047M
Instance name: xe
Redo thread mounted by this instance: 1
Oracle process number: 10
Windows thread id: 2452, image: ORACLE.EXE (CJQ0)
*** SERVICE NAME:(SYS$BACKGROUND) 2006-12-05 22:01:02.203
*** SESSION ID:(41.1) 2006-12-05 22:01:02.203
*** 2006-12-05 22:01:02.203
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kkbgenr+108] [PC:0x16710E8] [ADDR:0x2] [UNABLE_TO_WRITE] []
Current SQL statement for this session:
SELECT /*+ push_pred(v) */ U.NAME, OT.NAME, OT.SUBNAME, V.SPART, V.NAME, V.GLOB_ST, V.USER_ST, V.DISTCNT, V.DENSITY, V.SAMPLE_DISTCNT, V.SSIZE, V.NULL_CNT, V.TIMESTAMP#, V.AVGCLN, V.LOWVAL, V.HIVAL, V.MINIMUM, V.MAXIMUM, V.DMIN, V.DMAX, V.CCNT, V.BUCKET, V.ENDPOINT, V.EPVALUE, V.EAVS, V.FLAGS FROM SYS.USER$ U, SYS.OBJ$ OT, (SELECT /*+ ordered
use_nl_with_index(h) index(h I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST)
use_nl_with_index(hg) index(hg I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST)
*/ C.OBJ#, 2 TYPE#, NULL SPART, NULL CTIME, C.NAME, BITAND(H.FLAGS, 2) GLOB_ST, BITAND(H.FLAGS, 1) USER_ST, H.DISTCNT, H.DENSITY, H.SAMPLE_DISTCNT, NVL(H.SAMPLE_SIZE, 0) SSIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL DMIN, NULL DMAX, BITAND(H.FLAGS, 64) CCNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.FLAGS, 4) EAVS, H.FLAGS FROM SYS.COL$ C, SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY H, WRI$_OPTSTAT_HISTGRM_HISTORY HG WHERE :B2 IS NULL AND H.OBJ# = C.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# AND HG.SAVTIME(+) = H.SAVTIME AND H.SAVTIME > :B1 AND H.SAVTIME = (SELECT /*+ no_unnest */ MIN(CF.SAVTIME) FROM SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY CF WHERE CF.OBJ# = H.OBJ# AND CF.INTCOL# = H.INTCOL# AND CF.SAVTIME > :B1 ) UNION ALL SELECT /*+ ordered
use_nl_with_index(c)
use_nl_with_index(h) index(h I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST)
use_nl_with_index(hg) index(hg I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST)
*/ TP.OBJ#, 19 TYPE#, NULL SPART, NULL CTIME, C.NAME, BITAND(H.FLAGS, 2) GLOB_ST, BITAND(H.FLAGS, 1) USER_ST, H.DISTCNT, H.DENSITY, H.SAMPLE_DISTCNT, NVL(H.SAMPLE_SIZE, 0) SSIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL DMIN, NULL DMAX, BITAND(H.FLAGS, 64) CCNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.FLAGS, 4) EAVS, H.FLAGS FROM SYS.TABPART$ TP, SYS.COL$ C, SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY H, WRI$_OPTSTAT_HISTGRM_HISTORY HG WHERE C.OBJ# = TP.BO# AND H.OBJ# = TP.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# AND HG.SAVTIME(+) = H.SAVTIME AND H.SAVTIME > :B1 AND H.SAVTIME = (SELECT /*+ no_unnest */ MIN(CF.SAVTIME) FROM SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY CF WHERE CF.OBJ# = H.OBJ# AND CF.INTCOL# = H.INTCOL# AND CF.SAVTIME > :B1 ) UNION ALL SELECT /*+ ordered
use_nl_with_index(c)
use_nl_with_index(h) index(h I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST)
use_nl_with_index(hg) index(hg I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST)
*/ TP.OBJ#, 19 TYPE#, NULL SPART, NULL CTIME, C.NAME, BITAND(H.FLAGS, 2) GLOB_ST, BITAND(H.FLAGS, 1) USER_ST, H.DISTCNT, H.DENSITY, H.SAMPLE_DISTCNT, NVL(H.SAMPLE_SIZE, 0) SSIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL DMIN, NULL DMAX, BITAND(H.FLAGS, 64) CCNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.FLAGS, 4) EAVS, H.FLAGS FROM SYS.TABCOMPART$ TP, SYS.COL$ C, SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY H, WRI$_OPTSTAT_HISTGRM_HISTORY HG WHERE C.OBJ# = TP.BO# AND H.OBJ# = TP.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# AND HG.SAVTIME(+) = H.SAVTIME AND H.SAVTIME > :B1 AND H.SAVTIME = (SELECT /*+ no_unnest */ MIN(CF.SAVTIME) FROM SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY CF WHERE CF.OBJ# = H.OBJ# AND CF.INTCOL# = H.INTCOL# AND CF.SAVTIME > :B1 ) UNION ALL SELECT /*+ ordered
use_nl_with_index(ts)
use_nl_with_index(os)
use_nl_with_index(c)
use_nl_with_index(h) index(h I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST)
use_nl_with_index(hg) index(hg I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST)
*/ TP.OBJ#, 19 TYPE#, OS.SUBNAME SPART, OS.CTIME CTIME, C.NAME, BITAND(H.FLAGS, 2) GLOB_ST, BITAND(H.FLAGS, 1) USER_ST, H.DISTCNT, H.DENSITY, H.SAMPLE_DISTCNT, NVL(H.SAMPLE_SIZE, 0) SSIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL DMIN, NULL DMAX, BITAND(H.FLAGS, 64) CCNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.FLAGS, 4) EAVS, H.FLAGS FROM SYS.TABCOMPART$ TP, SYS.TABSUBPART$ TS, SYS.OBJ$ OS, SYS.COL$ C, SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY H, WRI$_OPTSTAT_HISTGRM_HISTORY HG WHERE C.OBJ# = TP.BO# AND TS.POBJ# = TP.OBJ# AND TS.OBJ# = OS.OBJ# AND OS.TYPE# = 34 AND H.OBJ# = OS.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# AND HG.SAVTIME(+) = H.SAVTIME AND H.SAVTIME > :B1 AND H.SAVTIME = (SELECT /*+ no_unnest */ MIN(CF.SAVTIME) FROM SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY CF WHERE CF.OBJ# = H.OBJ# AND CF.INTCOL# = H.INTCOL# AND CF.SAVTIME > :B1 ) ) V WHERE U.NAME = :B6 AND OT.OWNER# = U.USER# AND OT.NAME = :B5 AND OT.OBJ# = V.OBJ# AND (:B4 IS NOT NULL OR (:B2 IS NULL AND OT.SUBNAME IS NULL AND V.SPART IS NULL) OR (:B2 = OT.SUBNAME AND V.SPART IS NULL) OR :B2 = V.SPART) AND OT.TYPE# = V.TYPE# AND OT.TYPE# IN (2,19) AND FROM_TZ(CAST(NVL(V.CTIME, OT.CTIME) AS TIMESTAMP), :B3 ) <= :B1 ORDER BY 1,2,3,4,5,22
----- PL/SQL Call Stack -----
object line object
handle number name
15264040 885 package body SYS.DBMS_STATS_INTERNAL
1527FE50 16400 package body SYS.DBMS_STATS
1527FE50 16528 package body SYS.DBMS_STATS
1527FE50 16707 package body SYS.DBMS_STATS
1527FE50 18556 package body SYS.DBMS_STATS
1527FE50 18671 package body SYS.DBMS_STATS
1535B4CC 1 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_kkbgenr+108 00000000
*** 2006-12-05 22:01:02.375
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kkbgenr+108] [PC:0x16710E8] [ADDR:0x2] [UNABLE_TO_WRITE] []
Current SQL statement for this session:
SELECT /*+ push_pred(v) */ U.NAME, OT.NAME, OT.SUBNAME, V.SPART, V.NAME, V.GLOB_ST, V.USER_ST, V.DISTCNT, V.DENSITY, V.SAMPLE_DISTCNT, V.SSIZE, V.NULL_CNT, V.TIMESTAMP#, V.AVGCLN, V.LOWVAL, V.HIVAL, V.MINIMUM, V.MAXIMUM, V.DMIN, V.DMAX, V.CCNT, V.BUCKET, V.ENDPOINT, V.EPVALUE, V.EAVS, V.FLAGS FROM SYS.USER$ U, SYS.OBJ$ OT, (SELECT /*+ ordered
use_nl_with_index(h) index(h I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST)
use_nl_with_index(hg) index(hg I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST)
*/ C.OBJ#, 2 TYPE#, NULL SPART, NULL CTIME, C.NAME, BITAND(H.FLAGS, 2) GLOB_ST, BITAND(H.FLAGS, 1) USER_ST, H.DISTCNT, H.DENSITY, H.SAMPLE_DISTCNT, NVL(H.SAMPLE_SIZE, 0) SSIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL DMIN, NULL DMAX, BITAND(H.FLAGS, 64) CCNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.FLAGS, 4) EAVS, H.FLAGS FROM SYS.COL$ C, SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY H, WRI$_OPTSTAT_HISTGRM_HISTORY HG WHERE :B2 IS NULL AND H.OBJ# = C.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# AND HG.SAVTIME(+) = H.SAVTIME AND H.SAVTIME > :B1 AND H.SAVTIME = (SELECT /*+ no_unnest */ MIN(CF.SAVTIME) FROM SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY CF WHERE CF.OBJ# = H.OBJ# AND CF.INTCOL# = H.INTCOL# AND CF.SAVTIME > :B1 ) UNION ALL SELECT /*+ ordered
use_nl_with_index(c)
use_nl_with_index(h) index(h I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST)
use_nl_with_index(hg) index(hg I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST)
*/ TP.OBJ#, 19 TYPE#, NULL SPART, NULL CTIME, C.NAME, BITAND(H.FLAGS, 2) GLOB_ST, BITAND(H.FLAGS, 1) USER_ST, H.DISTCNT, H.DENSITY, H.SAMPLE_DISTCNT, NVL(H.SAMPLE_SIZE, 0) SSIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL DMIN, NULL DMAX, BITAND(H.FLAGS, 64) CCNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.FLAGS, 4) EAVS, H.FLAGS FROM SYS.TABPART$ TP, SYS.COL$ C, SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY H, WRI$_OPTSTAT_HISTGRM_HISTORY HG WHERE C.OBJ# = TP.BO# AND H.OBJ# = TP.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# AND HG.SAVTIME(+) = H.SAVTIME AND H.SAVTIME > :B1 AND H.SAVTIME = (SELECT /*+ no_unnest */ MIN(CF.SAVTIME) FROM SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY CF WHERE CF.OBJ# = H.OBJ# AND CF.INTCOL# = H.INTCOL# AND CF.SAVTIME > :B1 ) UNION ALL SELECT /*+ ordered
use_nl_with_index(c)
use_nl_with_index(h) index(h I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST)
use_nl_with_index(hg) index(hg I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST)
*/ TP.OBJ#, 19 TYPE#, NULL SPART, NULL CTIME, C.NAME, BITAND(H.FLAGS, 2) GLOB_ST, BITAND(H.FLAGS, 1) USER_ST, H.DISTCNT, H.DENSITY, H.SAMPLE_DISTCNT, NVL(H.SAMPLE_SIZE, 0) SSIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL DMIN, NULL DMAX, BITAND(H.FLAGS, 64) CCNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.FLAGS, 4) EAVS, H.FLAGS FROM SYS.TABCOMPART$ TP, SYS.COL$ C, SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY H, WRI$_OPTSTAT_HISTGRM_HISTORY HG WHERE C.OBJ# = TP.BO# AND H.OBJ# = TP.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# AND HG.SAVTIME(+) = H.SAVTIME AND H.SAVTIME > :B1 AND H.SAVTIME = (SELECT /*+ no_unnest */ MIN(CF.SAVTIME) FROM SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY CF WHERE CF.OBJ# = H.OBJ# AND CF.INTCOL# = H.INTCOL# AND CF.SAVTIME > :B1 ) UNION ALL SELECT /*+ ordered
use_nl_with_index(ts)
use_nl_with_index(os)
use_nl_with_index(c)
use_nl_with_index(h) index(h I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST)
use_nl_with_index(hg) index(hg I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST)
*/ TP.OBJ#, 19 TYPE#, OS.SUBNAME SPART, OS.CTIME CTIME, C.NAME, BITAND(H.FLAGS, 2) GLOB_ST, BITAND(H.FLAGS, 1) USER_ST, H.DISTCNT, H.DENSITY, H.SAMPLE_DISTCNT, NVL(H.SAMPLE_SIZE, 0) SSIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL DMIN, NULL DMAX, BITAND(H.FLAGS, 64) CCNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.FLAGS, 4) EAVS, H.FLAGS FROM SYS.TABCOMPART$ TP, SYS.TABSUBPART$ TS, SYS.OBJ$ OS, SYS.COL$ C, SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY H, WRI$_OPTSTAT_HISTGRM_HISTORY HG WHERE C.OBJ# = TP.BO# AND TS.POBJ# = TP.OBJ# AND TS.OBJ# = OS.OBJ# AND OS.TYPE# = 34 AND H.OBJ# = OS.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# AND HG.SAVTIME(+) = H.SAVTIME AND H.SAVTIME > :B1 AND H.SAVTIME = (SELECT /*+ no_unnest */ MIN(CF.SAVTIME) FROM SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY CF WHERE CF.OBJ# = H.OBJ# AND CF.INTCOL# = H.INTCOL# AND CF.SAVTIME > :B1 ) ) V WHERE U.NAME = :B6 AND OT.OWNER# = U.USER# AND OT.NAME = :B5 AND OT.OBJ# = V.OBJ# AND (:B4 IS NOT NULL OR (:B2 IS NULL AND OT.SUBNAME IS NULL AND V.SPART IS NULL) OR (:B2 = OT.SUBNAME AND V.SPART IS NULL) OR :B2 = V.SPART) AND OT.TYPE# = V.TYPE# AND OT.TYPE# IN (2,19) AND FROM_TZ(CAST(NVL(V.CTIME, OT.CTIME) AS TIMESTAMP), :B3 ) <= :B1 ORDER BY 1,2,3,4,5,22
----- PL/SQL Call Stack -----
object line object
handle number name
15264040 885 package body SYS.DBMS_STATS_INTERNAL
1527FE50 16400 package body SYS.DBMS_STATS
1527FE50 16528 package body SYS.DBMS_STATS
1527FE50 16707 package body SYS.DBMS_STATS
1527FE50 18556 package body SYS.DBMS_STATS
1527FE50 18671 package body SYS.DBMS_STATS
1535B4CC 1 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_kkbgenr+108 00000000
*** 2006-12-05 22:01:02.703
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_kkbgenr+108] [PC:0x16710E8] [ADDR:0x2] [UNABLE_TO_WRITE] []
Current SQL statement for this session:
SELECT /*+ push_pred(v) */ U.NAME, OT.NAME, OT.SUBNAME, V.SPART, V.NAME, V.GLOB_ST, V.USER_ST, V.DISTCNT, V.DENSITY, V.SAMPLE_DISTCNT, V.SSIZE, V.NULL_CNT, V.TIMESTAMP#, V.AVGCLN, V.LOWVAL, V.HIVAL, V.MINIMUM, V.MAXIMUM, V.DMIN, V.DMAX, V.CCNT, V.BUCKET, V.ENDPOINT, V.EPVALUE, V.EAVS, V.FLAGS FROM SYS.USER$ U, SYS.OBJ$ OT, (SELECT /*+ ordered
use_nl_with_index(h) index(h I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST)
use_nl_with_index(hg) index(hg I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST)
*/ C.OBJ#, 2 TYPE#, NULL SPART, NULL CTIME, C.NAME, BITAND(H.FLAGS, 2) GLOB_ST, BITAND(H.FLAGS, 1) USER_ST, H.DISTCNT, H.DENSITY, H.SAMPLE_DISTCNT, NVL(H.SAMPLE_SIZE, 0) SSIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL DMIN, NULL DMAX, BITAND(H.FLAGS, 64) CCNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.FLAGS, 4) EAVS, H.FLAGS FROM SYS.COL$ C, SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY H, WRI$_OPTSTAT_HISTGRM_HISTORY HG WHERE :B2 IS NULL AND H.OBJ# = C.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# AND HG.SAVTIME(+) = H.SAVTIME AND H.SAVTIME > :B1 AND H.SAVTIME = (SELECT /*+ no_unnest */ MIN(CF.SAVTIME) FROM SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY CF WHERE CF.OBJ# = H.OBJ# AND CF.INTCOL# = H.INTCOL# AND CF.SAVTIME > :B1 ) UNION ALL SELECT /*+ ordered
use_nl_with_index(c)
use_nl_with_index(h) index(h I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST)
use_nl_with_index(hg) index(hg I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST)
*/ TP.OBJ#, 19 TYPE#, NULL SPART, NULL CTIME, C.NAME, BITAND(H.FLAGS, 2) GLOB_ST, BITAND(H.FLAGS, 1) USER_ST, H.DISTCNT, H.DENSITY, H.SAMPLE_DISTCNT, NVL(H.SAMPLE_SIZE, 0) SSIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL DMIN, NULL DMAX, BITAND(H.FLAGS, 64) CCNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.FLAGS, 4) EAVS, H.FLAGS FROM SYS.TABPART$ TP, SYS.COL$ C, SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY H, WRI$_OPTSTAT_HISTGRM_HISTORY HG WHERE C.OBJ# = TP.BO# AND H.OBJ# = TP.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# AND HG.SAVTIME(+) = H.SAVTIME AND H.SAVTIME > :B1 AND H.SAVTIME = (SELECT /*+ no_unnest */ MIN(CF.SAVTIME) FROM SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY CF WHERE CF.OBJ# = H.OBJ# AND CF.INTCOL# = H.INTCOL# AND CF.SAVTIME > :B1 ) UNION ALL SELECT /*+ ordered
use_nl_with_index(c)
use_nl_with_index(h) index(h I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST)
use_nl_with_index(hg) index(hg I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST)
*/ TP.OBJ#, 19 TYPE#, NULL SPART, NULL CTIME, C.NAME, BITAND(H.FLAGS, 2) GLOB_ST, BITAND(H.FLAGS, 1) USER_ST, H.DISTCNT, H.DENSITY, H.SAMPLE_DISTCNT, NVL(H.SAMPLE_SIZE, 0) SSIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL DMIN, NULL DMAX, BITAND(H.FLAGS, 64) CCNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.FLAGS, 4) EAVS, H.FLAGS FROM SYS.TABCOMPART$ TP, SYS.COL$ C, SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY H, WRI$_OPTSTAT_HISTGRM_HISTORY HG WHERE C.OBJ# = TP.BO# AND H.OBJ# = TP.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# AND HG.SAVTIME(+) = H.SAVTIME AND H.SAVTIME > :B1 AND H.SAVTIME = (SELECT /*+ no_unnest */ MIN(CF.SAVTIME) FROM SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY CF WHERE CF.OBJ# = H.OBJ# AND CF.INTCOL# = H.INTCOL# AND CF.SAVTIME > :B1 ) UNION ALL SELECT /*+ ordered
use_nl_with_index(ts)
use_nl_with_index(os)
use_nl_with_index(c)
use_nl_with_index(h) index(h I_WRI$_OPTSTAT_HH_OBJ_ICOL_ST)
use_nl_with_index(hg) index(hg I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST)
*/ TP.OBJ#, 19 TYPE#, OS.SUBNAME SPART, OS.CTIME CTIME, C.NAME, BITAND(H.FLAGS, 2) GLOB_ST, BITAND(H.FLAGS, 1) USER_ST, H.DISTCNT, H.DENSITY, H.SAMPLE_DISTCNT, NVL(H.SAMPLE_SIZE, 0) SSIZE, H.NULL_CNT, H.TIMESTAMP#, H.AVGCLN, H.LOWVAL, H.HIVAL, H.MINIMUM, H.MAXIMUM, NULL DMIN, NULL DMAX, BITAND(H.FLAGS, 64) CCNT, HG.BUCKET, HG.ENDPOINT, HG.EPVALUE, BITAND(H.FLAGS, 4) EAVS, H.FLAGS FROM SYS.TABCOMPART$ TP, SYS.TABSUBPART$ TS, SYS.OBJ$ OS, SYS.COL$ C, SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY H, WRI$_OPTSTAT_HISTGRM_HISTORY HG WHERE C.OBJ# = TP.BO# AND TS.POBJ# = TP.OBJ# AND TS.OBJ# = OS.OBJ# AND OS.TYPE# = 34 AND H.OBJ# = OS.OBJ# AND H.INTCOL# = C.INTCOL# AND HG.OBJ#(+) = H.OBJ# AND HG.INTCOL#(+) = H.INTCOL# AND HG.SAVTIME(+) = H.SAVTIME AND H.SAVTIME > :B1 AND H.SAVTIME = (SELECT /*+ no_unnest */ MIN(CF.SAVTIME) FROM SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY CF WHERE CF.OBJ# = H.OBJ# AND CF.INTCOL# = H.INTCOL# AND CF.SAVTIME > :B1 ) ) V WHERE U.NAME = :B6 AND OT.OWNER# = U.USER# AND OT.NAME = :B5 AND OT.OBJ# = V.OBJ# AND (:B4 IS NOT NULL OR (:B2 IS NULL AND OT.SUBNAME IS NULL AND V.SPART IS NULL) OR (:B2 = OT.SUBNAME AND V.SPART IS NULL) OR :B2 = V.SPART) AND OT.TYPE# = V.TYPE# AND OT.TYPE# IN (2,19) AND FROM_TZ(CAST(NVL(V.CTIME, OT.CTIME) AS TIMESTAMP), :B3 ) <= :B1 ORDER BY 1,2,3,4,5,22
----- PL/SQL Call Stack -----
object line object
handle number name
15264040 885 package body SYS.DBMS_STATS_INTERNAL
1527FE50 16400 package body SYS.DBMS_STATS
1527FE50 16528 package body SYS.DBMS_STATS
1527FE50 16707 package body SYS.DBMS_STATS
1527FE50 18556 package body SYS.DBMS_STATS
1527FE50 18671 package body SYS.DBMS_STATS
1535B4CC 1 anonymous block
ksedmp: Obtaining call stack failed twice. not retrying