Hi
I am running Oracle Database 11g Release 11.2.0.1.0 - 64bit on Centos 5.9 64bit. The machine has 128GB RAM and 600GB SAS drives.
I daily get following in my alert.log and my database stops running queries.
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x38] [PC:0x2503528, pfrln0itinit()+60] [flags: 0x0, count: 2]
Fri Aug 09 04:57:21 2013
Sweep [inc][104359]: completed
Sweep [inc][104358]: completed
Fri Aug 09 08:35:49 2013
PMON failed to acquire latch, see PMON dump
Fri Aug 09 08:36:49 2013
PMON failed to acquire latch, see PMON dump
Fri Aug 09 08:38:19 2013
PMON failed to acquire latch, see PMON dump
Fri Aug 09 08:39:19 2013
Some parameters are:
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 12G
sga_target big integer 12G
SQL> show parameter memory
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 0
memory_target big integer 0
shared_memory_address integer 0
cat /proc/sys/kernel/shmmax
68719476736
cat /proc/sys/kernel/shmall
16777216
I don't have Oracle support contract therefore cannot contact them for help. Can someone please help?
Habib