RE: Performance problem with Shareplex and Oracle

Dan,

The process taking 50% is an Oracle process and it is connected on Shareplex Oracle user.

I have two different error messages:
1- "System call error: sp_cop(dsm) Temporary error (h_errno = 2) gethostbyname (can't add entry for ora4) I got this error every 10 minutes, but I didn't find something about this error.

2- "Operation on 'table_name' is took longer then expected. Make sure the proper index si being used"
If I check my Explain Plan, the Explain Plan says that he taking the proper index.
How can he tell me that it took longer that expected? It's true that on some replicated tables, I have lot of indexs. But my v$session_event should not tell me the waits on indexs (db file scattered read)?

Luc

-----Original Message-----
Sent: October 23, 2003 1:16 PM
To: Demanche, Luc

Luc,

Which process is taking 50% of the CPU? Do you see any messages from SharePlex? Are there indexes on the target tables or maybe a few that may be slowing down replication (you'll see a message in the event_log on any table that posting is taking longer than expected).

Has SharePlex been running for a while and this has just started happening? Just some things to start looking at.

Dan

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, October 23, 2003 8:29 AM

> 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).
>

-- 
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).