way to improve performance on delete or rollback?
- From: David Lord <dlordster@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 26 Mar 2010 15:49:36 +0000
Set up a guaranteed restore point before the testing begins and then
flashback to it at the end (see
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/rpfbdb001.htm#sthref486
).
Regards
David
On 26 March 2010 15:07, Dennis Williams <oracledba.williams@xxxxxxxxx>wrote:
> 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
>>
>>
>>
>
Other related posts:
