Re: connect slowly

From: James Williams <willjamu_at_mindspring.com>
Date: Sat, 20 Oct 2001 16:49:30 GMT
Message-ID: <3bd1aaa9.6562049@nntp.mindspring.com>

On Sat, 20 Oct 2001 10:31:50 +0900, "sang" <sang_at_technical-e.co.jp> wrote:

Sounds like you may have done a delete from the slow tables and then come behind them with inserts. The high water mark is not reset without a truncate or a export drop/create table and import.

>Hi, alls
>
>In my Database, I use OCI to develop my soft to connect to ORACLE 8.0.5.
>DB Server is Inter 586 128M RAM.
>I have five or six process running in different computers in one LAN.
>
>Some day i found that it is very slow to access to DB.
>It is very strange to me that some tables are very fast, while some tables
>are very slowly.
>The slowly tables are very small or emty.
>
>What i will do?
>
>Thanks in advance.
>
>webjb
>
>
>
Received on Sat Oct 20 2001 - 11:49:30 CDT