多項(xiàng)選擇題

Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.
Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）

A.the retention period to support flashback
B.the expected length of the longest-running query
C.the number of undo tablespaces in the database
D.the size of the Flash Recovery Area for the database instance

你可能感興趣的試題

單項(xiàng)選擇題

Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）

A.It is the time period after which the undo data becomes obsolete.
B.It is the time period after which the committed undo data would be transferred to a temporarytablespace.
C.It is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.
D.It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.

單項(xiàng)選擇題

In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）

A.when the data file of the undo tablespace is autoextensible
B.when there are more than one undo tablespaces available in the database
C.when the undo tablespace is of a fixed size and retention guarantee is not enabled
D.when the undo tablespace is autoextensible and retention guarantee is not enabled

你可能感興趣的試題

Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）

In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）

In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）