[prev in list] [next in list] [prev in thread] [next in thread] 

List:       suse-oracle
Subject:    RE: [suse-oracle] Oracle on multiple CPU's
From:       <michael.d.taylor () exgate ! tek ! com>
Date:       2006-08-28 19:12:10
Message-ID: 6CFB88F9A6EF4941970041EB633DB5C2D5E211 () us-bv-m24 ! global ! tektronix ! net
[Download RAW message or body]

Make sure you have the latest firmware updates for the server, and YaST
online updates of SLES9.  You should also be running Service Pack 3 of
SLES9.  Do a uname-a to verify you have the bigsmp kernel.  Are you
using RAC/ASM or ext3 or resierFS for filesystems?  Does you server have
4 physical CPUs, or are they 2 hyperthreaded ones?  As the system user,
run $ORACLE_HOME/rdbms/admin/addmrpt.sql and awrrpt.sql to ensure the
database is not starved for resources not allocated.

-Michael 

-----Original Message-----
From: Yu Safin [mailto:calanet@gmail.com] 
Sent: Friday, August 25, 2006 8:57 PM
To: suse-oracle@suse.com
Subject: [suse-oracle] Oracle on multiple CPU's

We have run into a situation that I can't figure out.
I took a Java application running against Oracle 9i on the same server
under aix with 4 CPU's and move it over to a Linux / Oracle 10.2g
platform on 4 CPU's.  In this environment the app fully uses the 4
cpu's to 100%.
When the application run on Linux / Oracle 10.2g, it only goes up to 1
or 2 CPU's and my total CPU utilization is very low.  The application
feels slower as well.
For Java, we are using the same amount of memory.
I can see Oracle with 10 threads but only 1 active at a time.
is there any parameter in Oracle that needs to be set up to
multi-thread?
I am not an Oracle guy and will appreciate detailed howTo's if possible
please.

-- 
To unsubscribe, email: suse-oracle-unsubscribe@suse.com
For additional commands, email: suse-oracle-help@suse.com
Please see http://www.suse.com/oracle/ before posting


-- 
To unsubscribe, email: suse-oracle-unsubscribe@suse.com
For additional commands, email: suse-oracle-help@suse.com
Please see http://www.suse.com/oracle/ before posting


[prev in list] [next in list] [prev in thread] [next in thread]