Use of Oracle Parallel Query

Oracle Parallel query is a query method accepted by more and more people. The following describes the advantages of Oracle Parallel query in detail. If you are interested in this aspect, take a look.

Use of the multiple CPU and Oracle Parallel Query PQO (Parallel Query Option) method:

1. Try to use multiple CPU processors for transaction processing and query

The rapid development of CPU makes ORACLE pay more and more attention to the application of multi-CPU Parallel technology. The access to a single database can be completed by the combination of multiple CPUs. In addition, distributed computing is already quite common, whenever possible, the CPU requests of the database server and the application should be separated, or the CPU requests should be moved from one server to another.

For multiple CPU Systems, use Parallel Query Option (PQO, Parallel Query Option) for database operations.

2. Use Parallel Query Option (PQO, select Parallel Query) to Query data

With the PQO method, you can not only allocate SQL statement request processing among multiple CPUs, but also read data from independent processes when the queried data is on different disks.

3. Use the SQL * Loader Direct Path option to load a large amount of data

When this method is used for data loading, the program creates formatted data blocks and writes them directly to the data file. other I/O of the database kernel is not required.

The preceding section describes the parallel query method of Oracle.

Implementation of parallel query of one column in oracle

Use of oracle rownum statements

Introduction to Oracle index rules

Oracle index type

How to create an Oracle Index