Interested to Buy Any Domain ? << Click Here >> for more details...
Is there any problem if we use commit repeatedly after each
dml statement in a plsq procedure ? (eg. there are 10 update
stmt and using 10 commit stmt after each update stmt)
- 1 Answers
- 5440 Views
- I also Faced
- E-Mail Answers
Answer / kiran iyer
Commiting a record frequently will effect the performance as
oracle internally would wait for the transaction to get
commited and then flush the RBS and then would go ahead and
read the Next Record. Hence it is not a good Practice to
commit records frequently. Records should be commited in a
batch.
| Is This Answer Correct ? | 4 Yes | 0 No |
Explain isolation levels. : Transact sql
How many commands are in sql?
How insert into statements in sql?
cursor types? explain with example programs?
what is meant by forward declaration in functions?
how many sql dml commands are supported by 'mysql'? : Sql dba
Give an example of any procedure.
5 Answers Accenture, iFlex, Wipro,
What is procedure explain with program?
What is assignment operator in pl sql?
What is consistency?
Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)
Why we use join in sql?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
