How frequently we can give commits in a plsql program?
I have a loop which consists inserts, the loop contains a commit for each record.
I have decided to commit for every 100 records,
Is there any to determine the maximum no. of records we can have for commit to have maximum efficiency, by looking at some system views, parameters etc.,
8/22/2022 - Mon
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst