Jeff,
I suspect there could be a problem with your Oracle rollback segments
(the one that your transcation actually uses could have reached its
maximum size). As 1 transaction uses exactly 1 rollback segment there is
no way to escape except to use bigger RB segments or to use smaller
transactions (commit more often).
You can force Oracle to use a certain rollback segment for your
transcation. Therefore you don't have to enlarge all your RB segments
but can set aside a special huge one (I do that regularly for whole
database imports with big tables).
But the first step should be a diagnostic one: examine the database
alert.log file to see if there are any hints.
Regards,
Frank.
jeff knot wrote:
>
> I have found that the problem ocuurs in many
> cases. For example, I use
> sqlload userid=scott/tiger control=load log=load.log
>
> to upload my data to the oracle. Once the data file
> is very long. The same problem also occurs: it is stuck.
>
> Jeff
>
> >From: "Sterin, Ilya" <[EMAIL PROTECTED]>
> >To: jeff knot <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> >Subject: RE: DBI buffer commit
> >Date: Wed, 2 May 2001 21:31:44 -0400
> >
> >Didn't know that SUN bought Oracle, but these days you never know,
> >especially when both of them are more focused on overthrowing Mico$oft than
> >their product:-) Kidding...
> >
> >Did you explicitly set AutoCommit => 0, if not you must do that in order to
> >use commit().
> >Not sure what is overflowing and why, did you get an error message? How do
> >you know it's overflowing? Use trace() (see 'perldoc DBI') to get the
> >trace
> >output and send to list.
> >
> >Ilya Sterin
> >
> >-----Original Message-----
> >From: jeff knot [mailto:[EMAIL PROTECTED]]
> >Sent: Wednesday, May 02, 2001 6:14 PM
> >To: [EMAIL PROTECTED]
> >Subject: DBI buffer commit
> >
> >
> >Hi,
> >I am new to this list and I have the following question:
> >
> >My database is SUN Oracle. I try to use
> >perl DBI to update the record:
> >$sth=$dbh->prepare("update mytable set filed=mynewrecord
> > where id=?");
> >$sth->execute ($i);
> >After doing the above over 1000 lines, my database stucks. I guess my
> >buffer
> > overflow. Then
> >I use $dbh->commit; trying to clear the buffer, but
> >it is not working. I am wondering if there is a solution.
> >
> >Jeff
> >
> >_________________________________________________________________
> >Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Dr. Frank Ullrich, Netzwerkadministration
Verlag Heinz Heise GmbH & Co KG, Helstorfer Str. 7, D-30625 Hannover
E-Mail: [EMAIL PROTECTED]
Phone: +49 511 5352 587; FAX: +49 511 5352 538
