core dumps
- From: raja rao <raja4list@xxxxxxxxx>
- To: oracle list <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 24 Oct 2005 02:18:50 -0700 (PDT)
when we are trying to perofrm inserts (parallelly 6 jobs),
out of theose, 2 jobs are getting succeeded. and rest 4 are failing
and we are getting a trace file (as well core file)
trace output is like this:
Redo thread mounted by this instance: 1
Oracle process number: 22
Unix process pid: 11366, image: oracle@srvr30 (TNS V1-V3)
*** 2005-10-23 06:53:38.653
*** SESSION ID:(49.46806) 2005-10-23 06:53:38.648
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr:
0xffffffff7bf00000, PC: [0x100602000, 0000000100
602000]
*** 2005-10-23 06:53:38.658
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [0000000100602000] [SIGSEGV]
[Address not mapped to object] [0xFFFFFFFF7BF00000] [
] []
Current SQL statement for this session:
INSERT INTO ifdata
SELECT
rpad('B230', 4), /* Record Type
*/
rpad(item_id, iffun.get_sysparmlength(519)), /* Part Number
*/
rpad('RepCsgn', iffun.get_sysparmlength(500)) || /* Schedule
Type AbbreviationID */
rpad(location, iffun.get_sysparmlength(513)) || /* Location */
rpad(' ', iffun.get_sysparmlength(511)) || /* Detail Key
*/
to_char(sysdate,'YYYYMMDD') || /* Period
*/
rpad('O', 1) || /*
Increment/Override */
rpad(on_hold_qty, 10) /* Quantity */
FROM gemed_prt_qty
WHERE item_id in (select partnum from GEMED_B100_ITEM WHERE repairable =
'Y')
----- PL/SQL Call Stack -----
object line object
handle number name
3a1d6c690 2511 package body IFGEMED.GEMED_PLAN_PROC
3a12ea2d8 5 anonymous block
3a1d92518 1120 package body SYS.DBMS_SYS_SQL
3a1da46a0 323 package body SYS.DBMS_SQL
3a1e708f8 712 package body IFGEMED.IFRUN
3a1e708f8 566 package body IFGEMED.IFRUN
3a1e3abb0 1 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+328 CALL ksedst()+0 00000000B ? 000000000 ?
000000000 ? 00000004A ?
FFFFFFFF7FFEEB78 ?
BD11EFBF:000027D2 77 0 10280 1 0x000000000000004D
BD19F30C:000027D3 77 0 10280 1 0x000000000000004D
KSTDUMP: End of in-memory trace dump
ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL
~
~
can someone throw some light on this, why we are getting the core when running
6 parallel inserts.
Thanks and regards,
Raj
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
Other related posts:
