View the Exhibit and examine the highlighted alert.
Exhibit #1
Exhibit #2
You have received an alert with the Category specified as Snapshot Too Old. Which page would you open from the Advisor Central page to determine the system recommendations to avoid such alerts in future?
A.
ADDM
B.
Memory Advisor
C.
Segment Advisor
D.
Undo Management
E.
SQL Tuning Advisor
F.
SQL Access Advisor
Explanation:
Improved automatic tuning of undo retention results in fewer “ORA-01555:snapshot too old” messages. Automatic tuning of undo retention now always tunes for the maximum possible retention for the undo tablespace based on tablespace size and current system activity. This improves the success rate of Oracle Flashback operations and long-running. This new tuning method for maximum possible retention applies only to fixed size undo tablespaces. For AUTOEXTEND tablespaces, the behavior is unchanged.
REF.: Oracle(r) 10g Administrator Guide, 2-25