Re: Performance problem with Shareplex and Oracle

With 2 CPUs, a Run-Queue of 1.27 isn't high. As SharePlex seems to be the only process taking CPU, it is taking 100% of 1 CPU. If it is one process only,
then the CPU speed __could__ [and I'm not saying "IS"] the constraint. Adding CPUs wouldn't help. However, upgrading to a faster CPU would help.
My comments are just a generalisation.

Hemant
At 07:29 AM 23-10-03 -0800, you wrote:
>Hi gurus,
>
>Oracle 8.1.7.3 on Sun Solaris
>One of our databases has been updated by Shareplex, and we have a huge
>performance problem....
>
>Shareplex is the only process running on this database.
>Here is the output of v$session_event
>
>SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
>AVERAGE_WAIT
>-- ------- ----------- -------------- ----------- ------------
>17 latch free 83 69 1 ,012048193
>17 log file sync 15 0 9 ,6
>17 db file sequential read 52 0 6 ,115384615
>17 file open 1 0 0 0
>17 SQL*Net message to client 74791 0 27 ,000361006
>17 SQL*Net message from client 74791 0 5235 ,069995053
>
>
>I really don't see any Oracle performance problems.....
>
>My problem is the backlog (queue) of Shareplex is getting bigger and bigger.
>Where is the bottleneck?
>
>The only thing I can see is the server. The server is a Ultra-80, 2 CPU
>450Mhz, 2048Megs of RAM
>According to "top", this process is taking 50% of the CPU.
>and my "load average" is 1.26, 1.27, 1.24
>
>My average load exceed 1, can I conclude that the CPU is the bottleneck?
>
>What are my possibilities?
>
>TIA
>Luc
>
>---------
>Luc Demanche
>AstraZeneca R&D Montreal
>Oracle Database Administrator
>514.832.3200 x2356
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author:
> INET: Luc.Demanche_at_astrazeneca.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).