The collection and usage of undo statistics is done to improve the efficiency of the undo tablespace. Undoing tablespaces teaches us what, if anything, we can learn. It's not totally clear who gets access to the undo tablespace's statistics. Oracle 11g has severe user requirements.

Thanks for the expert answer. However, can you tell me how to do the 2nd bullet in step 2 (Then go to UI create file format and create on the Load table)?

All of the APIs can return errors. Prepare, execute, bind_results. How defensive should our code get? In the event of errors in these fragments what should we do? Obviously, we are not doing anything right now ... should we do something and if so how should we structure our code to handle any detected errors?

Make a hard copy of update.txt in case you lose track of it on your computer.

Undo statistics are used to fine-tune the undo tablespace. Do undo tablespaces provide any useful information? Who has access to the undo tablespace's statistics and may examine them? There are strict rules in Oracle 11g.

Consider a view v whose definition solely refers to r. Does a user with update permission on v need to have update permission on r as well? So, why?

The collection and usage of undo statistics is done to improve the efficiency of the undo tablespace. Undoing tablespaces teaches us what, if anything, we can learn. It's not totally clear who gets access to the undo tablespace's statistics. Oracle 11g has severe user requirements.

There are many reasons to use the undo tablespace instead of the backup segment. Do you have proof?

'How to completely remove all restore points ?

Undo statistics fine-tune the undo tablespace. Are undo tablespaces informative? Who may see undo tablespace statistics? Oracle 11g is rigorous.