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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
