AUM has been retaining about 15 minutes worth of undo. You want to double the retentionperiod, but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However, AUM still retains only about 15 minutes worth of undo. What is the problem? ()
Which two statements are true regarding undo tablespaces()
Which three operations require undo data()
When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?()
Which two operations require undo data?()
View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT hasstarted a query on a large table in the peak transactional hour that performs bulk inserts. The query runs formore than 15 minutes and then SCOTT receives the following error:ORA-01555: snapshot too old What could be the reason for this error()
You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace, UNDO_TBS1, in your database. Which two additional steps would you perform to achieve this?()
What is true regarding a transaction executed in Automatic Undo Management mode?()
Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee: SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this statement have on the database?()
What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?()