Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DML too slow on some tables
On Mar 29, 10:51 am, "gazzag" <gar..._at_jamms.org> wrote:
> 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
have you considered partitioning the tables? Received on Thu Mar 29 2007 - 05:53:26 CDT