Home » Server Options » RAC & Failsafe » Invoking Parallel query
Invoking Parallel query [message #74867] Tue, 15 July 2003 15:13 Go to next message
Messages: 58
Registered: September 2000
I tried invoking the parallel query by setting the init ora parameters.

I have a dual 2 processor Sun v880 machine.
I set the parallel_min_servers to 0,
parallel_max_servers to 4
and enables parallel_automatic_tuning = true.

The way I test parallel dml, is open a SQL session as sysdba
run the alter session enable parallel dml command
run insert /* parallel (table_name,4) */ into select /* parallel (table_name,4) */ statement
(This table is a simple table with no partitions)

After the data is completely inserted I looked a the v$pq_sesstat view. I believe this view contains a statistic,DML Parallelized, that indicates thet total number of parallel DML statments issued for the session. I cannot find any parallel statements. Is this a good test for testing parallelism?

Can you give me some hints on why my parallel test did'nt work?


Re: Invoking Parallel query [message #74868 is a reply to message #74867] Sun, 03 August 2003 17:47 Go to previous message
Messages: 1
Registered: August 2003
Junior Member
turn off the parallel_automatic_tuning. It should work.
Previous Topic: Oracle availability check on Veritas Cluster
Next Topic: Parallel Server
Goto Forum:

Current Time: Mon Nov 28 02:23:15 CST 2022