Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL*net message from client severly impact the Parse call of an

Re: SQL*net message from client severly impact the Parse call of an

From: Jared Still <jkstill_at_cybcon.com>
Date: Wed, 31 Dec 2003 07:44:26 -0800
Message-ID: <F001.005DB5D2.20031231074426@fatcity.com>


Sorry, you can't send binary attachments to this list.

Jared

On Tue, 2003-12-30 at 23:34, Hatzistavrou John wrote:
> Dear All,
>
>
>
> I am faced with the following situation.
>
> Oracle 8.1.7.4. 64 bit , Solaris 8
>
>
>
> There is a loader java process that when is executed against a test
> database(dwdsa)the response time is as expected to be. However when it
> is executed against the production instance (dwods) it is 2,5 to 3 times
> slower.
>
> I have traced the session on both occasions and reading the book of
> Carry Milsap I have spotted that the WAIT for SQL*Net message from
> client is very high for the PARSE call of an INSERT statement, whereas
> for the test instance there is no delay.
>
> I cannot however explain what might be the cause of this. Can somebody
> sched some light into this problem.
>
> Attached please find the SQL 10046 trace with level 8
>
>
>
> a) Production trace (parser_dwods.zip)
>
> b) Test trace parser_dwdsa.zip
>
>
>
>
>
> Kind Regards,
>
>
>
>
>
> Hatzistavrou Yannis
>
>
>
> ----
>

> The previous attachment was filtered out by the ListGuru mailing
> software at fatcity.com because binary attachments are not appropriate
> for mailing lists. If you want a copy of the attachment which was
> removed, contact the sender directly and ask for it to be sent to
> you by private E-mail.
>
> This warning is inserted into all messages containing binary
> attachments which have been removed by ListGuru. If you have questions
> about this message, contact Postmaster_at_fatcity.com for clarification.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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 Wed Dec 31 2003 - 09:44:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US