Explain the hardware architecture used in oracle rac?
Answer / Santosh
The hardware architecture for Oracle RAC is designed to provide high availability and scalability. Key components include:
- Server Nodes: Each server node runs an instance of the database, and all nodes share access to a single database using the shared SCAN (Shared Server Connection) or dedicated servers (DSC).
- Storage: Shared storage is used for data files and redo logs. It can be a SAN (Storage Area Network), NAS (Network Attached Storage), or DAS (Direct Attached Storage).
- Interconnect Network: This network connects all the server nodes in the cluster and provides high-speed communication between them.
| Is This Answer Correct ? | 0 Yes | 0 No |
Why do we use materialized view instead of table or views?
What is tkprof?
Mention what is olr?
What do you mean by sga and how is it different from pga?
Mention what are the tools provided in oracle enterprise manager?
What are the various benefits of using rac architecture?
Where does the clusterware write when there is a network or storage issue?
What are the different optimizers that are used to optimize database?
What is a flashback query and when should it be used?
How can we monitor the space allocations in a database?
Mention what is new feature in oracle asm 12c?
How can we tune a sql query to optimize the performance of a database?