Switch operation waits for transactions in old undo tablespace to commit - Oracle Tablespaces

Q.  The switch operation waits for transactions in the old undo tablespace to commit.
- Published on 04 Aug 15

a. True
b. False

ANSWER: False
 

    Discussion

  • Nirja Shah   -Posted on 31 Aug 15
    - The true statement is:

    - The switch operation does not wait for transactions in the old undo tablespace to commit.

    - If there are any pending transactions in the old undo tablespace, the old undo tablespace enters into a PENDING OFFLINE mode (status).

    - In this mode, existing transactions can continue to execute, but undo records for new user transactions cannot be stored in this undo tablespace.

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.)