Re: Need help : degrading performance in record updates

On 14 mei, 07:49, Akshay..._at_gmail.com wrote:
> On May 13, 5:10 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
> wrote:
>
>
>
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
>
> > EscVector schreef:
>
> > > Well, you did ask... :) Sorry!
>
> > Just being grumpy - sorry.
>
> > > My question would be do they mean 100k*25.
>
> > That would be my understanding, now that I know they meant
> > 2,500,000 records. Which is nothing, really, and loads
> > on my 5 year old PC in about 5 minutes.
>
> > - --
> > Regards,
> > Frank van Bortel
>
> > Top-posting is one way to shut me up...
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1.4.1 (MingW32)
>
> > iD8DBQFGRwAiLw8L4IAs830RAv/SAJ9HxBh4C3rG6CgMrfsozxtwCY2ERACdGedl
> > bruZtHlDhNatQAF6TH8/LiI=
> > =PRGb
> > -----END PGP SIGNATURE-----
>
> Hello All,
>
> first of all my apologies for the "Lakh" thing.
>
> I need to use the batch program as I need to process the text file
> data to upload in the db.
> Frank, I am not a oracle person but a Java programmer.
> On the program side I have tried a couple of things to my
> understanding. Rechecked for any memory leaks possible, thoroughly.
> Tightened the code related to file reading.
>
> As for "Error02 : Commit slow"... I did not get your point.... do you
> say that, commits should be more frequent?
>

No - LESS frequent, as commits are slow.

> jg, yes, I am committing in a loop.

Standard receipe to get ORA-01555: Snapshot too old.
>
> yes, 100k*25 is the records per file.
>
> I connecting through a Dual Core 2.99GHz 1GB machine to another Dual
> Core 2.99GHz 1GB machine, both running WinXP Professional. And
> Oracle9i is the database. I just dont understand what could be the
> bottleneck :-(.
>
> Thank you in advance for any help/directions.
>
> :-)

As commecnted by several others, too: why not use the tool provided by Oracle for this type of actions: SQL*Loader?!?

Else, show the code. Received on Mon May 14 2007 - 06:04:29 CDT