Mike (71760.1371@COMPUSERVE.COM) wrote:
: > (My prior post had the wrong format for the Compuserve address)
: > We just added two more CPU's to our ORACLE 7.3.3.0.0 server (a Sun
: > Ultrasparc 4000 running Solaris 2.5) bringing the total up from 2 to 4
: > but have only seen a slight (16%) improvment in even the most
: > processor
: > intensive PL/SQL blocks.
: >
: > Do we have to make any changes to ORACLE in order to optimize it for
: > the new CPU's...?
: >
: > Does anyone know of a script that can generate some system stats for
: > performance tuning in general..?
: >
: > Thanks for the help.
: >
: > MJ
Mike,
To take advantage of additional CPUs, in your initSID.ora file add the line:
cpu_count=4
This will have Oracle take advantage of your 4 CPUs. Note that versions of
Oracle 7.3 and beyond will automatically detect the number of CPUs. To verify,
issue:
SELECT * FROM V$PARAMETER WHERE NAME LIKE '%cpu%';
As for tuning scripts,
try $ORACLE_HOME/rdbms/admin/utlbstat.sql and
$ORACLE_HOME/rdbms/admin/utlestat.sql. These come with Oracle and will
generate pages of statistics, a description of which is beyond the scope of
this email. The scripts have documentation to guide you further.
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 125+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page