On Mar 29, 10:25 am, "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
Partitioning?
Received on Thu Mar 29 2007 - 05:52:33 CDT
