utlrp.sql and lots of cores, ora-4031s.
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Jun 2009 12:30:47 -0400
In the event that you're applying the latest and greatest (e.g.
10.2.0.4 p22) to a dual socketed box that has 8 cores, you might be
surprised when you run utlrp.sql.
It might end up throwing memory errors (shared pool) during the
recompile due to lots of slave processes being used to recompile,
particularly if you ran the view recompile script as well.
I observed ora-4031 errors being thrown with a shared_pool_size of 256
MB with 8 cores (MS W2K3 R2 x64 standard edition).
So you'll want to know that the recommended minimum of 160 MB for the
shared_pool_size is not necessarily sufficient.
hth.
Paul
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » utlrp.sql and lots of cores, ora-4031s. - Paul Drake