Real Application Cluster (RAC)

1.What is Partition Pruning ? Oracle optimizes SQL statements to mark the partitions or subpartitions that need to be accessed and eliminates (prunes) unnecessary partitions or subpartitions from access by …

1.What is a diskgroup in ASM? A disk group consists of multiple disks and is the fundamental object that ASM manages. Each disk group contains the metadata that is required …

1.What is dynamic remastering? When will the dynamic remastering happens? Dynamic Remastering is ability to move the ownership of resource from one instance to another instance in RAC. Dynamic Resource …

1.How would to find location of OCR file when CRS is down?

1. What is RAC? RAC stands for Real Application cluster. It is a clustering solution from Oracle Corporation that ensures high availability of databases by providing instance failover, media failover …

1.What are the types of Oracle Cluster-Ware process for 10g on Unix/Linux?