Re: State Object dump - which function caused crash
From: Николаев Андрей Серапионович <Andrey.Nikolaev_at_rdtex.ru>
Date: Fri, 7 Feb 2014 12:19:58 +0400 (MSK)
Message-ID: <1265.37.1.14.29.1391761198.squirrel_at_webmail.rdtex.ru>
Hello!
>Looks like shared server S103 had shared pool allocation issue and pmon
hang during clean up attempt :).
Date: Fri, 7 Feb 2014 12:19:58 +0400 (MSK)
Message-ID: <1265.37.1.14.29.1391761198.squirrel_at_webmail.rdtex.ru>
Hello!
>Looks like shared server S103 had shared pool allocation issue and pmon
hang during clean up attempt :).
Actually, the problem was originated from another process "orapid=244" which holds "Child shared pool" latch for 72 seconds at location "kghdmp:old: heap descriptor " during SGA heap dump.
I would like suggest tuning of shared pool size and setting the parameter _4031_dump_bitvec=0 in order to avoid ORA-4031 dumps.
Best Regards.
Andrey Nikolaev
http://andreynikolaev.wordpress.com
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 07 2014 - 09:19:58 CET