The Research Of Massive Data Processing Capability Of DML Operation Basing On ORACLE RAC

With the extensive and further development of IT application, the traditional structure of the calculation can't meet the needs of enterprises with rapid development. Enterprises need their systems with the lowest cost, the most efficient and outstanding availability to serve enterprises. Indeed, their information systems usually respond slowly. To solve these problems, all enterprises had to build expensive infrastructure, but these facilities'excess capacity and redundancy are far from accidental incidents. Meanwhile, according to traditional DML Principles, even with adequate hardware to support, the data processing efficiency is still low.Oracle 10g is the first database designed for enterprise grid computing, it will bring many new technologies, and substantially improve the performance of the database. The rapid development of IT technology has made it impossible that Enterprises using Oracle 10g database can solve the problems of cost, performance, efficiency easily.Based on the research of Oracle 10g ,this article mainly analyzed the core mechanism of Oracle RAC, set up experiments to test the three major characteristics of Oracle RAC, and compared the performance of two-node with single-node. On the basis of the experimental data, this article also proposed a resolution to build a high performance and low cost cluster database platform using Oracle RAC 10g. On the platform of Oracle 10g RAC, using Oracle 10g bulk binds technology, this article finally presents a new DML solutions, which can deal with bulk data and solve the problem of low efficiency greatly.