| 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
Your DNS is toasty. Gethostbyname is a UNIX system call that takes your
ip address and turns it into a name. This could be a big part of your
delay. Networked apps do not take kindly to being unable to both
forward and reverse lookups. H_errno = 2 is not found.
Allan
-----Original Message-----
Sent: Thursday, October 23, 2003 1:40 PM To: Multiple recipients of list ORACLE-L
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
> 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
> -- ------- ----------- -------------- -----------
> 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). ______________________________________________________________________________ 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 - 14:49:41 CDT
 |
 |