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
- 7332 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what are the balancing segments in AR?
Plz anybody send me Technical specification for AP Interface
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
Which oracle apps version you are very confident in?
please send me forms, xml pulisher questions,answers
What is the concept of soa governance?
Can we create tables in apps schema?
q)what are the validations in sql*loader
What is count(*) from po_vendors(any table)?
tell me the scenarios of the independent in reports
What is oracle soa suite and what are its different components?
what is the difference between request group and request security in oracle apps?
Do you know what is applysys in oracle application database schema, what is apps?
how to print multi lay outs,muti currency,muti language in xml publisher
How to move the one file from one instance to another instance? And your scripts also?
