| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Performance problem with Shareplex and Oracle
How big is the box that is the source for this machine? Have you tried
running sp_ctrl and doing a shutdown and startup?
Allan
-----Original Message-----
Sent: Thursday, October 23, 2003 10:30 AM To: Multiple recipients of list ORACLE-L
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
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
-- 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). ______________________________________________________________________________ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: anelson_at_midf.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).Received on Thu Oct 23 2003 - 10:59:53 CDT
 |
 |