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_at_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.
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 24 2005 - 04:21:14 CDT