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