Re: DML too slow on some tables

On 29 Mar, 11:25, "Andrea" <netsecur..._at_tiscali.it> wrote:
> Hi,
> i've a 9i DB for OLTP database type. Some tables is quiet large (about
> 3/4 million of rows, size 500/600Mb) and when i launch query or DML
> transactions it is too slow.
>
> I've already analyzed schema with dbms_stats.schema.. , check chained
> row, tuning OS, but is all ok.
> I would like to know if there is a method for improving performance of
> big table, some tips or advise :)
>
> thanks very much.
> bye
> --
> Andrea

To get help, provide the following information:

1. Oracle and operating system versions.
2. Details of the structure of the table(s) involved.
3. Examples of the DML causing you problems.
4. An explain plan if the above DML.

HTH -g Received on Thu Mar 29 2007 - 05:51:14 CDT