utlrp.sql and lots of cores, ora-4031s.
From: Paul Drake <bdbafh_at_gmail.com>
Date: Wed, 17 Jun 2009 12:30:47 -0400
Message-ID: <910046b40906170930h2a31d653w68b0fbe719406aa0_at_mail.gmail.com>
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.
Date: Wed, 17 Jun 2009 12:30:47 -0400
Message-ID: <910046b40906170930h2a31d653w68b0fbe719406aa0_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 17 2009 - 11:30:47 CDT