way to improve performance on delete or rollback?
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 26 Mar 2010 04:45:50 -0700 (PDT)
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
Other related posts:
