Re: oracle database memory access becomes slow after restart
From: GG <grzegorzof_at_interia.pl>
Date: Sun, 19 Aug 2012 18:20:48 +0200
Message-ID: <50311260.1020708_at_interia.pl>
W dniu 2012-08-19 13:02, Николаев Андрей Серапионович pisze:
> Hello!
>
> This seems very similar to problem discussed in MOS Note
> "Oracle database restart takes longer on high end systems running Oracle
> Solaris[TM] [ID 1003483.1]"
>
> I have met this issue several times when the SGA occupied almost all RAM.
>
> The workaround is:
> set pg_contig_disable=1 in /etc/system and reboot the Solaris.
>
> Also decrease of SGA can help.
>
Nice catch, looks like this is related to some old bug: Bug 6642475 : page_get_contig_pages() can be extremely slow http://knowledgebase.progress.com/articles/Article/P147903
Date: Sun, 19 Aug 2012 18:20:48 +0200
Message-ID: <50311260.1020708_at_interia.pl>
W dniu 2012-08-19 13:02, Николаев Андрей Серапионович pisze:
> Hello!
>
> This seems very similar to problem discussed in MOS Note
> "Oracle database restart takes longer on high end systems running Oracle
> Solaris[TM] [ID 1003483.1]"
>
> I have met this issue several times when the SGA occupied almost all RAM.
>
> The workaround is:
> set pg_contig_disable=1 in /etc/system and reboot the Solaris.
>
> Also decrease of SGA can help.
>
Nice catch, looks like this is related to some old bug: Bug 6642475 : page_get_contig_pages() can be extremely slow http://knowledgebase.progress.com/articles/Article/P147903
From MOS:
Fix Request Attributes:
Fix Request # 6642475/solaris_11u1 Target solaris_11u1 Customer Status 10-Fix Delivered Severity 2-High Duplicate Of Committed Version s11u1_15 Fixed Version s11u1_15 Integrated Version s11u1_15 Verified Version Last Updated 2012-05-21 00:00:00 GMT+00:00
and its fixed in sol11 if I get it right .
Some diagnostics during occurance can be made via: lockstat -cwPW
Look up for high page_trylocks
Regards
GregG
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Aug 19 2012 - 11:20:48 CDT