Re: way to improve performance on delete or rollback?

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.
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: