This forum is currently locked. You can't register or post questions at this time. (read more)

Flashback Table Times

All posts relating to Oracle database administration.

Moderator: Tim...

dnunknown
Advisor
Posts: 292
Joined: Wed Aug 01, 2007 5:35 pm
Location: Boulder, CO USA

Flashback Table Times

Postby dnunknown » Mon Oct 08, 2012 7:02 pm

Hi Tim,

11.2.0.1.0

I was wondering what parameters should be looked into for increasing performance of Flashback, we are flashing back a series of tables

I am testing on a table that is 2.3M rows, its size is 346MB, it is taking 6 minutes to delete all the data w/ row movement enabled and 5 minutes to flash it back

I have ensured there is enough room in the FRA and the db_recover_file_dest_size, also increased the number of redo log groups. There are no constraints or indexes on the table

A couple of blogs are saying log_buffer should be increased, any thoughts?

Of course we are only going to be as fast as the disk presented to the FRA

Thanks,
Steve

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Flashback Table Times

Postby Tim... » Tue Oct 09, 2012 6:09 am

Hi.

I guess the obvious question is, "What is using all the time?". :)

Before you know what to do to fix anything, you need to know the root cause of the performance issue. What are the predominant wait states associated with the flashback operation? If you trace it, you will know where the time is being spent and that will give you an idea of what you can do to improve the performance.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 4 guests

cron