Re: Lock wait timeout exceeded; try restarting transaction
Posted by:
Ra Nala
Date: January 08, 2016 06:23AM
When i go through the link which is provided by you. they suggested us to kept chunk size 1000. but in my case i used 300000 it might be problem in my scenario.
why i kept chunk size 300000 is, when my ETL(pdi) tool iterate the job so many times i may get java heap space error.
Anyhow Sir, please correct me if i kept size is too much high.
Subject
Views
Written By
Posted
12518
January 07, 2016 05:28AM
3010
January 07, 2016 10:47PM
3082
January 08, 2016 12:45AM
Re: Lock wait timeout exceeded; try restarting transaction
2272
January 08, 2016 06:23AM
2348
January 09, 2016 11:52PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.