Re: connect slowly

From: sang <sang_at_technical-e.co.jp>
Date: Mon, 22 Oct 2001 10:15:21 +0900
Message-ID: <9qvqrm$s2g$1@nn-os106.ocn.ad.jp>

Thanks.

In my db, one process inserts data to this table, and another process does something with the data, and then deletes this table . So, it is used to be templete table which working for mutil-application.

Now , i am very ancious for this, it took me three days! Please tell me more details about it.

Thanks in advance.

webjb

"James Williams" <willjamu_at_mindspring.com> wrote in message news:3bd1aaa9.6562049_at_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 Sun Oct 21 2001 - 20:15:21 CDT