Abstract
Parallel execution is the ability to apply multiple CPU’s and IO resources to the execution of a single database operation. A major advantage of Oracle Database 10g’s parallel execution architecture is its ability to leverage the underlying hardware infrastructure to its fullest extent using every single CPU, every byte of memory, and the fully available I/O bandwidth. Oracle Database 10g is the only prominent vendor that implements dynamic parallelism at execution time by shared everything approach (every server can directly access every disk). Oracle Database 10g’s Real Application Clusters (RAC) provide near linear scalability and availability for high volume, mission-critical applications, thus providing unlimited power and growth for your systems. Oracle Real Application Clusters uses modern cluster interconnect facilities to reduce disk I/O and can exploit the emerging high bandwidth low latency interconnects to provide cost-effective scalability. It fully exploits the expanded CPU, memory and disk resources of the clustered system to drive more transactions. Cache Fusion™ is a fundamental component of Oracle’s Real Application Cluster configuration, a shared-cache clustered-database architecture that transparently extends database applications from single systems to multi-node shared-disk clusters. Shared disk might be important bottleneck of whole system if it is not intelligent enough to satisfy different application i/o needs. Application aware storage architecture helps to solve this. In addition, this project presents a simulation of concurrent disk access to a RAID disk . This simulation thus provide insight into sophisticated mass storage resource demands presented by modern applications.