Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DML too slow on some tables

DML too slow on some tables

From: Andrea <netsecurity_at_tiscali.it>
Date: 29 Mar 2007 03:25:51 -0700
Message-ID: <1175163951.126736.100930@p77g2000hsh.googlegroups.com> 





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


Received on Thu Mar 29 2007 - 05:25:51 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US