ora-600 . Pls Analyze the trace file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ora-600 . Pls Analyze the trace file

  1. #1
    Join Date
    Dec 2001
    Posts
    120
    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

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    your problem surely came from an index on your base table ...
    note : deleting a view is useless since a view only is a query
    I copied below some doc from metalink (for those who cannot access this more than useful site) :


    Problem Description:
    ====================

    You may receive an ORA-600 [12700] in one of the following scenarios
    where an index is used:

    1. select, update, delete queries,
    2. calling stored procedures.
    3. running pro*c or pl/sql application
    4. ora 600 [12700][1409438660][32] using a BITMAP index.
    5. and other possible scenarios.


    Problem Explanation:
    ====================

    Some possible reasons you may receive this error are:

    1. Some detected cases are problems when doing a query (doing consistent
    read) using an index but the corresponding row to be fetch from the
    data block is inconsistent (most likely does not exist).

    The more common case is when there is an index split and CR has to roll
    it back so you may see this [12700] when there are queries against
    growing indices.

    Other cases may happen when there are heavy update and query activities
    against the same set of data.

    2. There is a corruption, usually in the index. Doing an analyze table
    validate structure cascade will catch any corruption. In these cases,
    dropping and recreating the object will solve the error.

    3. If you alter a column that has a BITMAP index, the index is flagged
    as invalid.


    Search Words:
    =============

    ORA-600 [12700]

    Solution Description:
    =====================

    There have been many bugs that have been filed for this internal error. Many
    are closed and unreproducible, mainly due to insufficient information. So here
    are some steps to gather enough information so that Oracle Support Services
    can help determine what is the cause of the ORA-600 [12700] error:

    1. Check for any trace files generated at the time the error occurred.
    Look for the ORA-600 trace files, SQL trace files, etc. Search the
    database alert log for other related errors.

    2. Run analyze on the object you received the error on to check for any
    corruptions:

    SQL> ANALYZE TABLE VALIDATE STRUCTURE CASCADE;

    3. If the ANALYZE returns with errors, it is likely that a data block is
    corrupted. Save the trace file produced, as well as a dump of the redo
    log of that data block. Refer to the DBA in the trace file. (This may
    require the assistance of Oracle Support Services.)

    4. In some cases it is the index that is corrupted and so dropping and
    recreating the index will resolve the problem. In the case of a BITMAP
    index that is flagged as invalid, dropping and recreating the index
    will correct this error.


    Solution Explanation:
    =====================

    Analyzing the object and gathering all relevant trace files will aid in
    determining the cause of this error.

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Its very difficult to get any idea from this trace.Why dont u use tkprof to make this more readable.You may be able to find a solution for your issue

    cheese
    anandkl
    anandkl

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by anandkl
    Its very difficult to get any idea from this trace.Why dont u use tkprof to make this more readable.
    THis is server's trace file, not the one created by SQL trace facility. You can't use tkprof with such trace file, this kind of files are ment to aid Oracle Support at debugging process or finding the cause of the problems. One should contact Oracle Support if ORA600 is reported.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Dec 2001
    Posts
    120

    sending trace file to oracle support


    could you pls let me know the mail ids of oracle support team wherein such trace files should be sent.

    thanks

    paul

  6. #6
    Join Date
    Feb 2001
    Location
    Atlanta, USA
    Posts
    131
    Hi, Parijat67

    If you are registered user of Oracle, you would have got a valid CSI no (Customer Support Id). Right ?

    Using this no, you can logon to the "metalink.oracle.com". and then you can open a fresh TAR or iTAR, stating your problem. Then your TAR will be assigned / handled by Oracle Support professionals.

    Customer Support Ph.No for Bangalore is: 080-5593930




    Anandharaj
    a_anandharaj@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width