Questions

1)what is oracle server ?

2)what is oracle instance ?

3)what is SGA ? and what is it consist of ?

4)what is redolog buffer ?

5)what happens when commit complete?

6)what is purpose of redolog buffer and database buffer cache ?



1)what are the types of standby databases ?

2)What is physical standby database ?

3)what is logical standby database ? what is advantage and disadvantage ?

4)what is snapshot standby database ? what is advantage and disadvantage ?

5)what are types of  apply services ?

6)what is redo apply services ?

7)what is sql apply services ?




How to get the information of redo data generated per second ?