Re: Slow process

> My system is a Oracle EE 8.1.7.4 64bit on Solaris 8 .
>
> The last days the datawarehouse people complain that their load process
> which inserts data into tables is half time as fast as it was two days
> ago.
>
>
>
> From v$session_wait I can see that the process is spending time on
> SQL*Net message from client.
>
> The process is running on server and it is using PROTOCOL=BEQ and not
> TCP.
Waiting on a client might imply that the client process is causing the slowdown, not the database.

To be completely sure you should have this info before it slowed down as well. Maybe the Wait for SQL*Net message from client might have been there before, and something else might have gotten slower.

Try tracing with 10046 and analyze where it is waiting for what, to get more detailed info.

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Carel-Jan Engel
  INET: cjpengel.dbalert_at_xs4all.nl

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