Oracle DB Optimization Question:
Do you know what are the ways to code efficient transactions?
Answer:
We shouldn't allow input from users during a transaction.
We shouldn't open transactions while browsing through data.
We should keep the transaction as short as possible.
We should try to use lower transaction isolation levels.
We should access the least amount of data possible while in a transaction.
We shouldn't open transactions while browsing through data.
We should keep the transaction as short as possible.
We should try to use lower transaction isolation levels.
We should access the least amount of data possible while in a transaction.
| Previous Question | Next Question |
| Tell me in brief the cursor optimization tips? | Explain Execution Plan? |