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 …
Read More »
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 …
Read More »
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 …
Read More »
1.How would to find location of OCR file when CRS is down?
Read More »
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 …
Read More »
1.What are the types of Oracle Cluster-Ware process for 10g on Unix/Linux?
Read More »
Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner