Truncate On Fri, Mar 26, 2010 at 6:45 AM, dba1 mcc <mccdba1@xxxxxxxxx> wrote: > We have ORACLE 10GR2 on Linux servers. Users are using ORACLE ODI tool to > perform testing. Those testing will insert 20 to 30 millions records to > tables then it will 'delete" or "rollback" data. Users complain "delete" > or "rollback" 20 to 30 millions records take long time to finish. > > Does there has way to improve "delete" or "rollback" performance by setup > DB parameters like SGA, PGA, ...? > > Thanks. > > > > -- > //www.freelists.org/webpage/oracle-l > > >