I have a prob - dbload very slow at start...

Hi everyone, I have a problem with dbload, and I'm hoping someone can help me: I'm reloading a table in a database after I've deleted it and updated the statistics. The problem is that at the beginning of the load, the first 25000 rows take about 2 hours to load, and then it takes 4 minutes to load the next 325000. I thought it might be a "one time" problem, but it consistently happens when I load this and another table. Let me know what kind of config info you need to know about. Thanks, Mike

MICHAEL MEINHARDT said: > Hi everyone, > > I have a problem with dbload, and I'm hoping someone can help me: > > I'm reloading a table in a database after I've deleted it and updated the > statistics. The problem is that at the beginning of the load, the first > 25000 > rows take about 2 hours to load, and then it takes 4 minutes to load the > next > 325000. > > I thought it might be a "one time" problem, but it consistently happens > when I > load this and another table. > > Let me know what kind of config info you need to know about. What happens if you drop the table and re-create it? -- Bye now, Obnoxio "There were a myriad of problems which conspired to corrupt your reason and rob you of your common sense. Fear got the best of you, and in your panic you turned to the Labour Party. They promised you order, they promised you peace, and all they demanded in return was your silent, obedient consent."

Hi Michael Try to edit a file to control the load and mention it in dbload command as -c ! Put in it the 'commit' at 100000 lines... and check the results. BR R Ferronato > To: ids@iiug.org > From: obnoxio@serendipita.com > Subject: Re: I have a prob - dbload very slow at start... [11978] > Date: Tue, 6 May 2008 10:54:38 -0400 > > MICHAEL MEINHARDT said: > > Hi everyone, > > > > I have a problem with dbload, and I'm hoping someone can help me: > > > > I'm reloading a table in a database after I've deleted it and updated the > > statistics. The problem is that at the beginning of the load, the first > > 25000 > > rows take about 2 hours to load, and then it takes 4 minutes to load the > > next > > 325000. > > > > I thought it might be a "one time" problem, but it consistently happens > > when I > > load this and another table. > > > > Let me know what kind of config info you need to know about. > > What happens if you drop the table and re-create it? > > -- > Bye now, > Obnoxio > > "There were a myriad of problems which conspired to corrupt your reason > and rob you of your common sense. Fear got the best of you, and in your > panic you turned to the Labour Party. They promised you order, they > promised you peace, and all they demanded in return was your silent, > obedient consent." > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ News, entertainment and everything you care about at Live.com. Get it now! http://www.live.com/getstarted.aspx

MICHAEL MEINHARDT wrote: Try increasing the EXTENT SIZE of the table when you recreate it after the drop and before trying to reload it. > Hi everyone, > > I have a problem with dbload, and I'm hoping someone can help me: > > I'm reloading a table in a database after I've deleted it and updated the > statistics. The problem is that at the beginning of the load, the first 25000 > rows take about 2 hours to load, and then it takes 4 minutes to load the next > 325000. > > I thought it might be a "one time" problem, but it consistently happens when I > load this and another table. > > Let me know what kind of config info you need to know about. > > Thanks, > Mike > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org)

Does this table has default extent sizes? If yes, well it could be too many extens then. As suggested by other, drop and recreate with begger extents would be a good option but remember to create all objects depend on this table. I would also try to disble indexes before loading data and enable after load. MICHAEL MEINHARDT <mmeinhardt@riteaid.com> wrote: Hi everyone, I have a problem with dbload, and I'm hoping someone can help me: I'm reloading a table in a database after I've deleted it and updated the statistics. The problem is that at the beginning of the load, the first 25000 rows take about 2 hours to load, and then it takes 4 minutes to load the next 325000. I thought it might be a "one time" problem, but it consistently happens when I load this and another table. Let me know what kind of config info you need to know about. Thanks, Mike ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. --------------------------------- Get the name you always wanted with the new y7mail email address.