title: Do the time of the COMMIT and ROLLBACK affect performance?
body: <p>Suppose I have a set of ID . For each ID , I will insert many records to many different tables based on the ID .Between inserting difference tables, different business checks will be called . If any checking  fail , all the records that are inserted based on this ID will be ROLLBACK .This bulk insert action is done through using PL/SQL .  Do the time of the COMMIT and ROLLBACK affect the performance and how does it affect ? For example , should I COMMIT after finish the process for one ID or COMMIT after finish all ID?</p>