This preview shows page 1. Sign up to view the full content.
Unformatted text preview: B: The user peter will be created with SYSTEM tablespace as the default and TEMP tablespace
as the temporary tablespace.
D: The code above is correct, user peter will be successfully created.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 466
Chapter 10: Managing Database Use
An oracle user receives the following error:
ORA-01555 SNAPSHOP TOO OLD
What are two possible solutions? (Choose two)
A. Increase the extent size of the rollback segments.
B. Perform media recovery.
C. Increase the number of rollback segments.
D. Increase the size of the rollback segment tablespace.
E. Increase he value of OPTIMAL storage parameter.
Answer: A, E
Answers A and E are correct. Recall that rollback segments allow transaction-level read
consistency for all statements running on the database. A long-running query in one session that
starts before a change on that data is committed by another session will see the data as it existed
pre-commit. I Oracle can not provide a read-consistent view of data, the following error will
ensure "ORA-01555 - snapshot too old (rollback segment too small)&quo...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09