Oracle Memory Management Question: Download Questions PDF
What is use of rollback segments in Oracle database?
Answer:
When a user updated a particular table (for example 100 rows) the old value will be retained in the roll back segments(Oracle 8) and now it is Undo segment (oracle 9i). If the user issue a rollback command the old value will be taken from the rollback segment(that too if undo_retention parameter set properly in the parameter file).
Download Memory Management Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What are disadvantages of having raw devices? | What is advantage of having disk shadowing / mirroring? |