From oracle-l-bounce@freelists.org Fri Sep 3 05:39:28 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i83AdSS16816 for ; Fri, 3 Sep 2004 05:39:28 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i83AdSI16810 for ; Fri, 3 Sep 2004 05:39:28 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 791FC72C2AA; Fri, 3 Sep 2004 05:42:02 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24063-35; Fri, 3 Sep 2004 05:42:02 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A8F9072C305; Fri, 3 Sep 2004 05:41:48 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 03 Sep 2004 05:40:03 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CA3BC72C09C for ; Fri, 3 Sep 2004 05:40:02 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 20530-52 for ; Fri, 3 Sep 2004 05:40:02 -0500 (EST) Received: from shardagate.mahindrabt.com (shardagate.mahindrabt.com [210.18.48.2]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3E0E572C088 for ; Fri, 3 Sep 2004 05:40:01 -0500 (EST) Received: from Interscan_sh ([10.5.2.145]) by shardagate.mahindrabt.com (8.12.10/8.12.10) with ESMTP id i83AoW7K031618 for ; Fri, 3 Sep 2004 16:20:34 +0530 Received: from intranet.sharda.mahindrabt.com ([10.5.0.15]) by Interscan_sh with InterScan Messaging Security Suite; Fri, 03 Sep 2004 16:17:54 +0530 Received: from IMSS-1 ([10.5.3.66])by intranet.sharda.mahindrabt.com (8.12.10/8.12.10) with ESMTP id i83As9QD024483for ; Fri, 3 Sep 2004 16:24:09 +0530 Received: from dscp02181 ([172.24.85.144]) by IMSS-1 with InterScan Messaging Security Suite; Fri, 03 Sep 2004 16:08:11 +0530 From: "Charu Joshi" To: "Oracle List" Subject: Re: URGENT :- Session 'stuck up' on null event Date: Fri, 3 Sep 2004 16:13:16 +0530 Message-ID: MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Importance: Normal X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:30.92862 C:10 M:2 S:5 R:5 X-imss-settings: Baseline:1 C:1 M:1 S:1 R:1 (0.0000 0.0000) X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 9052 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: joshic@mahindrabt.com Precedence: normal Reply-To: joshic@mahindrabt.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@freelists.org&subject=unsubscribe To read recent messages - http://freelists.org/archives/oracle-l/09-2004