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
- 5382 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 |
what is the difference between delete and truncate statement in sql? : Sql dba
What are different types of refreshment techniques of materialised view
what is meant by tuning and tk proof?
Explain spool.
How do I filter in sql profiler?
Does sap use sql?
What is cursor and its types?
Types of cursors and explanation each of them ?
What is a trigger ?
11 Answers Accenture, BirlaSoft,
Difference between global and parameter variables?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What are actual parameters and formal parameters?
-
Oracle (3259) - 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)
