Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a) Why we prefer the undo tablespace instead of backup segment. Justify your answer with logical reasoning b) Suppose you want to modify the retention
a) Why we prefer the undo tablespace instead of backup segment. Justify your answer with logical reasoning b) Suppose you want to modify the retention time to manage the long undo tablespace. This can help you to undo a large amount of data. As a DBA, what factor you need to know to modify or increase the undo Retention and how you can implement that factor in oracle 11 g c) Suppose you want to move from one tablespace to another tablespace. How can you automatically switch from one tablespace to another tablespace? Please write the procedure and implement it in oracle 11g. d) Undo statistics are used to tune the undo tablespace. Who can you manage or view the statistics of the undo tablespace what kind of information a undo tale space have? You need to implement the steps in oracle 11g
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started