I am insert in data to a table X .Which one is better while
writing commit statement
After each row inset or after all row insert to table.
- 3 Answers
- 8666 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
I think its better to use the savepoint when ever u want to
save till the specific insert.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kiddu
the best way is committing after all rows inserted but suppose we are using a proc that is inserting huge data suppose 4k or 5k records then its better to commit in every 1000 records to avoid "Snapshot too old error".
| Is This Answer Correct ? | 0 Yes | 0 No |
what are the balancing segments in AR?
What is sca and how is it useful?
what are the prerequisite set ups for inter organization transaction?
what are the prerequisites for costing transactions?
what is the differences between internal requisition and internal sales order?
what is po approval hierarchy?
what is MRC? Why it is needed?
In which table or database definition we can find the link of organization and operation units.
What should be the batch size (number of customer records) general guidelines for optimal performance?
i have 3 parameters like p1,p2,p3.In p1 i have 2 parameters like a,b.if pass parameter 'a' p2 should be enable and p3 should be disable then if pass parameter 'b' the vice versa.
1 Answers IBM, Sierra Atlantica,
What is the concept of soa governance?
what is the data type of lexical parameter?
Oracle Apps Technical 
