Is it possible to disable data memory oversight in your data warehouse

Asked By fabian 0 points N/A Posted on - 01/02/2012

To my understanding, it is possible to disable the data memory oversight in your data warehouse.

Can you please affirm or correct my knowledge?

If possible, I also want to inquire on how to go about this process; including the migration of data to specific bins.

May I also ask for a reference of the step-by-step guide to help me with the process?

Thank you. 

• Status: Open
• Question Views: 787
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Thompson Locker 10 points N/A #117472

Is it possible to disable data memory oversight in your data warehouse

I guess it is possible for you to be able to disable the data memory oversight when working on your data warehouse. To able to carry out that process successfully, you will need to first of all create a redo log, which is basically a set of files that will help you in the protection of the altered database data in memory before it can be written to the data files.

You can make then redo log online, whereby you will have a set of two or more online redo log files that will record all changes that will be made to the database, and they will include both the changes that have been uncommitted and also those that have already been committed.

The redo entries in this case will be temporarily stored in redo log buffers of the system global area.

Thompson Locker

 

About Thompson Locker

Questions
0

Answers
619

Best Answers
77

• Vote Up 0 Vote Down

• Posted on - 01/03/2012
• Question Category: Database