Hi,

1)I got ORA-600 error while accessing records from a particular view. When i dropped the view and its base table and recreated both of them then the error got eliminated. Things are working fine now. I just want to know what caused the error & how it got rectified by first dropping the base table and the view and then recreating them once again. The trace file (4 pages out of 850 pages) is given below.

2)The other error about which I want more information is : "Session 116 exceeded soft sessionspace limit of 0x100000 bytes." , what does soft sessionspace mean?


thanks

Parijat Paul
---- the trace file is given below-----------

*** SESSION ID:(117.9894) 2001-09-08 18:09:23.656
Session 116 exceeded soft sessionspace limit of 0x100000 bytes.
Dump file D:\oracle\admin\gendb\udump\ORA00235.TRC
Thu Jan 24 15:56:34 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows NT Version 4.0 Service Pack 5, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows NT Version 4.0 Service Pack 5, CPU type 586
Instance name: gendb

Redo thread mounted by this instance: 1

Oracle process number: 40

Windows thread id: 235, image: ORACLE.EXE


*** SESSION ID:(126.11357) 2002-01-24 15:56:34.515
*** 2002-01-24 15:56:34.515
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [12700], [79910], [12671975], [43], [], [], [], []
Current SQL statement for this session:
SELECT message FROM Messages
WHERE messageCode = :1
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedmp+a8 CALLrel _ksedst+0
656D8FC
_ksfdmp+e CALLrel _ksedmp+0 3
_kgeriv+95 CALLreg 00000000
3331BF0
3
_kgeasi+67 CALLrel _kgeriv+0
B3F00
165E452C
319C
3
1656DA74
_qertbFetchByRowID+5ac CALLrel _kgeasi+0
3331BF0
165E452C
319C
2 3 0
13826
0
C15BE7
0 2B
_opifch+c0f CALL??? 00000000
CD32E4
AE4E20
1656DCB0
2
_opiall0+d11 CALLrel _opifch+0 5 2
1656DD64
_opial7+153 CALLrel _opiall0+0
_opiodr+506 CALLreg 00000000 47 F
1656EF84
_ttcpip+df8 CALLreg 00000000 47 F
1656EF84
5
_opitsk+608 CALLrel _ttcpip+0
_opiino+50c CALLrel _opitsk+0 0
_opiodr+506 CALLreg 00000000 3C 4
1656FBFC
_opidrv+384 CALLrel _opiodr+0 3C 4
1656FBFC
0
_sou2o+19 CALLrel _opidrv+0
_opimai+10c CALLrel _sou2o+0
_OracleThreadStart@4+49f CALLrel _opimai+0 2
1656FE78
77F04EE5 CALLreg 00000000
----- Argument/Register Address Dump -----
Argument/Register addr=1656d8fc.
Dump of memory from 0x1656D8BC to 0x1656D9FC
1656D8B0 00000003 [....]
1656D8C0 00000000 65522117 00000033 00000000 [.....!Re3.......]
1656D8D0 00000003 1656D891 00000000 00000000 [......V.........]
1656D8E0 00000000 23331A68 00000000 0000001D [....h.3#........]
1656D8F0 1656D908 0041E204 00000001 00E191B4 [..V...A.........]
1656D900 00E191B4 00E191D4 00E191B4 00E191B4 [................]
1656D910 00E191AC 00E191B4 00E191B4 00E191BC [................]
1656D920 00E191BC 00E191B4 00E191B4 00E191BC [................]
1656D930 00E191B4 00E191B4 00E191B4 00E191B4 [................]
1656D940 00E191BC 00000003 2A2A2A0A 30303220 [.........*** 200]
1656D950 31302D32 2034322D 353A3531 34333A36 [2-01-24 15:56:34]
1656D960 32332D25 2D252073 25207338 7332332D [%-32s %-8s %-32s]
1656D970 00000020 00000000 00000002 000007DF [ ...............]
1656D980 35363120 37454636 25200038 7332332D [ 1656FE78. %-32s]
1656D990 342D2520 00000A73 00000005 6552216C [ %-4s.......l!Re]
1656D9A0 23330033 00000000 00000000 6003DD27 [3.3#........'..`]
1656D9B0 00000000 00000000 00000000 1656FFEC [..............V.]
1656D9C0 00000000 1656FE78 00000000 00000001 [....x.V.........]
1656D9D0 00000001 00000000 1656D414 0000000D [..........V.....]
1656D9E0 1656DA08 00477F2D 1656D944 165E452C [..V.-.G.D.V.,E^.]
1656D9F0 23331BF0 23331C64 6003D452 [..3#d.3#R..`]
Argument/Register addr=23331bf0.
Dump of memory from 0x23331BB0 to 0x23331CF0
23331BB0 23331BB0 23331BB0 0004000C 23331BBC [..3#..3#......3#]
23331BC0 23331BBC 0008000C 23331BC8 23331BC8 [..3#......3#..3#]
23331BD0 0020000C 23331BD4 23331BD4 165E75A4 [.. ...3#..3#.u^.]
23331BE0 165E0054 165E42B0 00000000 00000000 [T.^..B^.........]
23331BF0 0139F140 165E76CC 23331AC0 00000000 [@.9..v^...3#....]
23331C00 165DDA1C 165E604C 23335EE0 00000000 [..].L`^..^3#....]
23331C10 165DDA7C 165DD4E0 00000000 00000000 [|.]...].........]
23331C20 00000001 00000000 00000000 00000000 [................]
23331C30 00000000 00000000 00000000 62B061E8 [.............a.b]
23331C40 00001000 00000000 00000000 00000000 [................]
23331C50 0000000C 00000010 00000000 165E452C [............,E^.]
23331C60 165E4404 1656DBE0 00000000 165E452C [.D^...V.....,E^.]
23331C70 00000002 00000258 23331FF0 00000004 [....X.....3#....]
23331C80 00000028 00000000 00000000 00000000 [(...............]
23331C90 00000000 00000000 00000000 00000000 [................]
Repeat 5 times
Argument/Register addr=eb3f00.
Dump of memory from 0xEB3EC0 to 0xEB4000
EB3EC0 6F6C2042 6F746163 70732072 66696365 [B locator specif]
EB3ED0 3A646569 41524F20 3232322D 00003537 [ied: ORA-22275..]
EB3EE0 0041E1D0 0041E210 00C9B864 004E61C0 [..A...A.d....aN.]
EB3EF0 007AD220 007AD240 007AD260 007AD280 [ .z.@.z.`.z...z.]
EB3F00 0041E1D0 007AC9A0 007AC9C0 007AC9E0 [..A...z...z...z.]
EB3F10 007AC9F0 00000000 00000000 007ACA10 [..z...........z.]
EB3F20 007ACAB0 007ACAE0 007ACB90 007ACD80 [..z...z...z...z.]
EB3F30 007ACDB0 007ACE30 007ACE50 007ACEF0 [..z.0.z.P.z...z.]
EB3F40 007ACF30 007ACF40 007ACF50 007ACF70 [0.z.@.z.P.z.p.z.]
EB3F50 007ACF90 007AD080 007AD0C0 007AD1B0 [..z...z...z...z.]
EB3F60 0047A4F0 007ACC70 007ACC90 000003F5 [..G.p.z...z.....]
EB3F70 00000259 007ACCB0 007ACCE0 007ACD00 [Y.....z...z...z.]
EB3F80 007ACD40 00E38230 00000150 00EB3EE0 [@.z.0...P....>..]
EB3F90 00000000 00000000 000001B8 000000A4 [................]
EB3FA0 00000070 00000034 00000024 007ACD60 [p...4...$...`.z.]
EB3FB0 00000068 007ACBF0 00536C60 006704B0 [h.....z.`lS...g.]
EB3FC0 006704B0 006704B0 006704B0 006704B0 [..g...g...g...g.]
EB3FD0 006704B0 00ABD2E0 006704B0 006704B0 [..g.......g...g.]
EB3FE0 006704B0 00ABC190 00ABBDA0 006704B0 [..g...........g.]
EB3FF0 006704B0 00000000 00471990 00CA4300 [..g.......G..C..]
Argument/Register addr=165e452c.
Dump of memory from 0x165E44EC to 0x165E462C
165E44E0 00000000 [....]
165E44F0 00000000 00000000 00000000 00000000 [................]
165E4500 00000000 00000000 06432510 23335E98 [.........%C..^3#]
165E4510 00000000 00000000 00000000 00000000 [................]
165E4520 00000000 00000000 00000000 165E4554 [............TE^.]
165E4530 165E46F0 00000258 0000025B 00000000 [.F^.X...[.......]
165E4540 00000000 00000000 00000000 165E4FE8 [.............O^.]
165E4550 165E4FEC 00000094 00000294 00000394 [.O^.............]
165E4560 00000694 00320099 00010032 00000001 [......2.2.......]
165E4570 00000000 00990000 00990099 00990099 [................]
165E4580 00990099 02820676 2C2E2C2E 0000242C [....v....,.,,$..]
165E4590 00000000 00000000 00000001 0000002D [............-...]
165E45A0 00000000 00000000 00000001 00000000 [................]
165E45B0 00000000 00000000 00000000 4D2D4444 [............DD-M]
165E45C0 522D4E4F 00000052 00000000 00000000 [ON-RR...........]
165E45D0 00000000 00000000 00000000 00000009 [................]
165E45E0 2C2E2C2E 0000242C 00000000 00000000 [.,.,,$..........]
165E45F0 00240000 00000000 00000000 00990100 [..$.............]
165E4600 2016180E 00000001 0032007F 00990000 [... ......2.....]
165E4610 00990099 00990099 0000007F 00000000 [................]
165E4620 00000000 00000000 00000000 [............]
Argument/Register addr=1656da74.
Dump of memory from 0x1656DA34 to 0x1656DB74
1656DA30 6003D8DC 00EB3F00 165E452C [...`.?..,E^.]
1656DA40 0000319C 00000003 1656DA74 23331A68 [.1......t.V.h.3#]
1656DA50 134299D8 23331C64 1656DB74 00C4C0F1 [..B.d.3#t.V.....]
1656DA60 23331BF0 165E452C 0000319C 00000002 [..3#,E^..1......]
1656DA70 00000003 00000000 00013826 00000000 [........&8......]
1656DA80 00C15BE7 00000000 0000002B 23331C64 [.[......+...d.3#]
1656DA90 00AE4E20 23331A68 13424310 FFFFFFFF [ N..h.3#.CB.....]
1656DAA0 23331A68 23331A68 00000000 77664297 [h.3#h.3#.....Bfw]
1656DAB0 00000A8C 00000600 00000000 00000000 [................]
1656DAC0 1656DB30 776642B6 00000600 00000A8C [0.V..Bfw........]
1656DAD0 00000002 00000006 23331C64 1656DBE0 [........d.3#..V.]
1656DAE0 165D730C 00000000 00000000 00000000 [.s].............]
1656DAF0 00000000 00000000 13429CF0 13429CF4 [..........B...B.]
1656DB00 04CD332C 00000000 00000000 00000600 [,3..............]
1656DB10 00000000 1656DB34 1656DAD8 031E7810 [....4.V...V..x..]
1656DB20 23331A68 134299A8 00004000 00000000 [h.3#..B..@......]
1656DB30 00000000 04CD32E4 134299D8 04E015F4 [.....2....B.....]
1656DB40 00000002 04CD32E4 134299D8 00000000 [.....2....B.....]
1656DB50 16560000 00000000 13422A01 1656DA8C [..V......*B...V.]
1656DB60 00000000 1656DCFC 00CA5AC0 00DEC0D8 [......V..Z......]
1656DB70 FFFFFFFF [....]
18197F10 00000000 00000000 04331819 33181A2E [..........3....3]
18197F20 181B2E04 182E1831 22200233 20023318 [....1...3. ".3. ]
18197F30 0433182F 0018303A 00000010 00000000 [/.3.:0..........]
18197F40 00000000 00000000 00000000 00000000 [................]
Repeat 12 times
18198010 00000000 16000000 2D043318 0433181F [.........3.-..3.]
18198020 3318282D 18192002 1A2E0433 2E043318 [-(.3. ..3....3..]
18198030 1831181B 0233182E 00182220 00000010 [..1...3. "......]
18198040 00000000 00000000 00000000 00000000 [................]
Repeat 12 times