Re: oracle database memory access becomes slow after restart

From: GG <>
Date: Sun, 19 Aug 2012 18:20:48 +0200
Message-ID: <>

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

 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


Received on Sun Aug 19 2012 - 11:20:48 CDT

Original text of this message