Steps to manage undo segments & space among various active sessions automatically - Oracle Tablespaces

Q.  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?
- Published on 12 Aug 15

a. Set the UNDO_RETENTION parameter to 900 or more
b. Create an initial undo segment in the undo tablespace
c. Set the UNDO_TABLESPACE parameter to UNDO_TBS1
d. Set the UNDO_MANAGEMENT initialization parameter to AUTO
e. Both C & D

ANSWER: Both C & D
 

    Discussion

  • Nirja Shah   -Posted on 31 Aug 15
    - Oracle provides a fully automated mechanism, referred to as automatic undo management, for managing undo information and space.

    - In this management mode, you create an undo tablespace, and the server automatically manages undo segments and space among the various active sessions.

    - You set the UNDO_MANAGEMENT initialization parameter to AUTO to enable automatic undo management.

    - If the database contains multiple undo tablespaces, you can optionally specify at startup that you want to use a specific undo tablespace.

    - This is done by setting the UNDO_TABLESPACE initialization parameter, as shown in this example:

    UNDO_TABLESPACE = undotbs_01

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)