Oracel 9i Undo

50 pts.
Tags:
Oracle 9i
How can i determine if the undo is setup properly and how can i determine if it is online

Answer Wiki

Thanks. We'll let you know when a new response is added.

You cannot start a database without undo space. You have to choose between the MANUEL and AUTOMATIC mode management. It is recommand to run in automatic mode. To configure the auto mode, follows the steps below:

1) Create an undo tablespace:
<b>CREATE UNDO TABLESPACE undotbs_01
DATAFILE ‘path_of_the_file_.dbf’ SIZE 2M REUSE AUTOEXTEND ON;</b>

2) In your parameter file add the lines bellow
<b>- UNDO_MANAGEMENT=AUTO
– UNDO_TABLESPACE= undotbs_01</b>

After perfoms steps 1 and 2, start your database. Now it is running in auto undo management mode.
You can execute the following command at the prompt of sqlplus to see the mode and the tablespace of undo: <b>Show parameter undo;</b>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following