Re: Interested in Solving Some Problems

V. Chandrasekhar <shaker_at_netusa1.net> wrote in article <01bcab29$0ef3d180$45d896ce_at_shakerv>...

> (1) The database is fairly full. (I realize that I have not
> defined what 'fairly' is. There appears to be definitely room
> for adding the rows.) This seems to slow the
> application - i.e., the inserts - down. I am surprised by
 this.
> As long as all that is happening is adding new rows, will
> the size of the database have an effect, as long as there
> is room ? I hear that this is because Oracle is trying to fit
> in rows where there are gaps in files - where rows have been
> created and deleted. Shouldn't the solution be to get rid of
> the gaps by running a maintenance utility ?
>

Following up on my own posting, I just realized that there are about 40 instances of the 'one' application; all of these write (i.e., insert) to the same tables. Each instance is a separate unix process. I wonder whether the real problem is the processes locking each other out.

Shaker Received on Mon Aug 18 1997 - 00:00:00 CDT