DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Why this trace file is generated ?

  1. #1
    Join Date
    Oct 2001
    Location
    Calcutta , India
    Posts
    78

    Question Why this trace file is generated ?

    Hi,

    I am using Oracle ver 9.2.0.3 on solaris ver 9.Everyday I can see that in user_dump_dest , a trace file is generated whoose size is 2 mb (arround) at different times. Now I can not understand why it is generated. Can u tell me the reasona and workaround . Thanx

    The contents of trace file :

    Exception signal: 10 (SIGBUS), code: 1 (Invalid address alignment), addr: 0xc2045222, PC: [0x14870fc, opixguid()+16]
    *** 2004-02-05 11:00:12.981
    ksedmp: internal or fatal error
    ORA-07445: exception encountered: core dump [opixguid()+16] [SIGBUS] [Invalid address alignment] [0xC2045222] [] []
    Current SQL statement for this session:
    select decode(filter_predicates,NULL,:"SYS_B_0",id||:"SYS_B_1"||:"SYS_B_2"||filter_predicates)||
    id||:"SYS_B_3"||:"SYS_B_4"||access_predicates
    from v$sql_plan
    where hash_value = :"SYS_B_5"
    --and child_number = 0
    and access_predicates is not null
    ----- Call Stack Trace -----
    calling call entry argument values in hex
    location type point (? means dubious value)
    -------------------- -------- -------------------- ----------------------------
    ksedmp()+248 CALL ksedst()+0 2CA1040 ? 2CA101C ? C ? 0 ?
    FFBF8B94 ? 2CA1000 ?
    ssexhd()+488 CALL ksedmp()+0 3 ? 1 ? D ? FFBF9124 ? 1 ?
    6 ?
    sigacthandler()+40 PTR_CALL 00000000 A ? FFBF9800 ? FFBF9548 ?
    FF1BA000 ? 0 ? 0 ?
    opixguid()+16 PTR_CALL 00000000 A ? FFBF9800 ? FFBF9548 ?
    FFBF98F0 ? 0 ? 2E1127C ?
    OCIKGetConn()+36 FRM_LESS opixguid()+0 C2045202 ? FFBF98F0 ?
    FFBF98EC ? FFBF98F0 ? 0 ?
    2E1127C ?
    msqpfn()+440 CALL OCIKGetConn()+0 43414E00 ? FFBF9960 ?
    FFFFFFFC ? FEE5D7DD ? 22 ?
    FB24C2B5 ?
    msqfun()+1264 CALL msqpfn()+0 FFBF9FF0 ? 9E2DD2F0 ? A9 ?
    A90000 ? C ? 0 ?


    --------------------- Binary Stack Dump ---------------------

    ========== FRAME [1] (ksedmp()+248 -> ksedst()+0) ==========
    %l0 0000000C %l1 FFBF8358 %l2 FFBF83B0 %l3 FFBF8324 %l4 FFBF83B0
    %l5 02CA1080 %l6 00000000 %l7 00000000 %i0 02CA1040 %i1 02CA101C
    %i2 0000000C %i3 00000000 %i4 FFBF8B94 %i5 02CA1000 %fp FFBF8FC0
    rtn-pc 001CE938 argd FFBF5BCC stret FFBF5BC8 xtraarg FFBF901C
    locals FFBF5BE8
    Dump of memory from 0xFFBF5B88 to 0xFFBF5F88
    ..
    ...
    ....
    .....

    Deba

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    because an ora-7445 is being - generated - raise a tar

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