Re: URGENT :- Session 'stuck up' on null event

From: Charu Joshi <joshic_at_mahindrabt.com>
Date: Fri, 3 Sep 2004 16:13:16 +0530
Message-ID: <MHEAIPLKCACENJKNJIALOEBDCGAA.joshic@mahindrabt.com>

Ganesh,

>> If you see the wait event ..
>> Oracle is not Waiting on that event anymore..

You are right - the state 'WAITED KNOWN TIME' suggests that. But the SECONDS_IN_WAIT count was increasing continuously indicating that the event was continuously occurring.

Anyway, that session has been killed and the only entries it wrote into the trace file (probably after it was killed) are ORA-7445 error followed by core dump. Given below is the snippet of the core dump, in case anyone is interested.

Looks like I will have to search on Metalink and take the iTAR way if required.

Thanks & regards,
Charu.

ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [000000010158BDF0] [SIGSEGV] [Address not mapped to object] [0x000000008] [] [] Current SQL statement for this session:
INSERT /*+ APPEND */ INTO recon_gen_sbl_sub_missing_stg

    (SELECT ROW_NUMBER() OVER (ORDER BY mpn), a.*

     FROM (SELECT   mpn,
                    assetcreateddate start_date,
                    assetlastupdated end_date,
                    'Geneva' missing_from,
                    billing_account_number
           FROM  recon_sbl_subs_data od
           WHERE od.STATUS = 'Active'
             AND NOT EXISTS (SELECT mpn
                             FROM   recon_geneva_subs_stg gd
                             WHERE  gd.latest_mpn = od.mpn
                               AND  gd.latest_mpn_end_dt IS NULL
                               AND  gd.asset_end_dt IS NULL)
           UNION
           SELECT  latest_mpn mpn,
                   asset_start_dt start_date,
                   asset_end_dt end_date,
                   'Siebel' missing_from,
                   billing_account
           FROM    recon_geneva_subs_stg gd
           WHERE   gd.latest_mpn_end_dt IS NULL
             AND   gd.asset_end_dt IS NULL
             AND   NOT EXISTS (SELECT mpn
                               FROM   recon_sbl_subs_data od
                               WHERE  od.mpn = gd.latest_mpn
                                 AND  od.status = 'Active')) a)
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
4029c9cb410       191  procedure SIEBEL.RECON_EXTRACT_PROC
4029a10e8f8         2  anonymous block
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- -------------------------
---
ksedmp()+328         CALL     ksedst()+0           FFFFFFFF7FFF2FA0 ?
                                                   000000000 ? 000000000 ?
                                                   00000003E ?
                                                   FFFFFFFF7FFF3838 ?
                                                   1031D06C8 ?



*********************************************************
Disclaimer:          

This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.

---

Visit us at http://www.mahindrabt.com

---
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004

Received on Fri Sep 03 2004 - 05:39:28 CDT