Re: URGENT :- Session 'stuck up' on null event
- From: "Charu Joshi" <joshic@xxxxxxxxxxxxxx>
- To: "Oracle List" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 3 Sep 2004 16:13:16 +0530
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@xxxxxxxxxxxxx&subject=unsubscribe
To read recent messages - //freelists.org/archives/oracle-l/09-2004
Other related posts:
