Re: Performance problem with Shareplex and Oracle

Who's using other 50%? Is SP active or is waiting? On 10/23/2003 02:19:32 PM, Luc.Demanche_at_astrazeneca.com wrote:
> Allan,
>
> I don't know about the source machine.
> I receive around 350Megs of data every day.
>
> I'm using sp_ctrl to stop and restart my Post process and monitor the
> queue.
>
> I'm pretty sure that the bottleneck come from Shareplex. Oracle is
> waiting
> for Shareplex, we have server's resources available (CPU is 50%
> idle).
>
>
> How can we speed up Shareplex?
>
> Luc
>
> -----Original Message-----
> Sent: October 23, 2003 12:56 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
> ,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).
>
>
> ____________________________________________________________________________
> __
> 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).
>

Mladen Gogala
Oracle DBA

Note:
This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mladen_at_wangtrading.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).