How can we identify the resources for which the sessions are waiting?
Mention what is cluster?
What are the different tools that are provided by oracle to assist performance monitoring?
What is required by oracle rac database to connect to a network?
What is olr?
What is rac and what are the various benefits of using rac architecture?
Explain the oracle grid infrastructure?
How can we use tkprof?
What are the key components of oracle’s maximum availability architecture?
How would you differentiate between cluster and grid?
Mention what is the difference between instance recovery and crash recovery?
Mention how can you determine what protocol is being used for interconnect traffic?
Mention what is the function of cache fusion in oracle rac?
What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?
What do you understand by redo log file mirroring?