The Oracle Alchemist has an interesting blog on this topic: http://www.oraclealchemist.com/oracle/hey-guys-does-size-matter/ On Mon, Mar 1, 2010 at 9:53 AM, Jared Still <jkstill@xxxxxxxxx> wrote: > On Mon, Mar 1, 2010 at 7:30 AM, Saad Khan <saad4u@xxxxxxxxx> wrote: > >> >> But that has done some reorg but I dont think that will resolve the >> original performance issue. The "do something" song is still being drummed >> on my head. >> >> > I can't recall from the original thread: > > Has this operation been traced? > > Do you know where it is spending time? > > If you don't know where the time is going, you can't fix the problem. > > > Jared Still > Certifiable Oracle DBA and Part Time Perl Evangelist > Oracle Blog: http://jkstill.blogspot.com > Home Page: http://jaredstill.com > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'