On Mon, Dec 24, 2012 at 8:52 PM, Michael Dinh <mdinh235@xxxxxxxxx> wrote: > Hello, > Does anyone have any experience with updating compressed table? > > The only difference between 2 tables is no compression vs OLTP compression. > > PL/SQL using FOR loop updating 1 row and a time and commit every 10,000 > rows. > Michael, This would be an excellent opportunity to use Tom Kyte's runstats<http://appsdba.com/techinfo/runstats.htm> ( modified version and original both available there) Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com -- //www.freelists.org/webpage/oracle-l