Database Administrator (DBA) Question:
Download Job Interview Questions and Answers PDF
Explain an ORA-01555
Answer:
You get this error when you get a snapshot too old within rollback. It can usually be solved by increasing the undo retention or increasing the size of rollbacks. You should also look at the logic involved in the application getting the error message.
Download Database Administrator (DBA) Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How would you go about increasing the buffer cache hit ratio? | Explain the difference between $ORACLE_HOME and $ORACLE_BASE. |