2.Explain in detail the Advanced Query Optimization Techniques.

3.A database is extremely active (lot of inserts, updates and deletes operations). The redo log buffer of 8M is manually set and in every a second 1M of data is written to redo log. LGWR process writes 1M from redo log buffer to online redo log file in a second. How much of redo log buffer is used at any point of time? You as an administrator, what do you do for effective memory (Redo buffer) management?