Home » Server Options » RAC & Failsafe » Invoking Parallel query
Invoking Parallel query [message #74867] Tue, 15 July 2003 15:13 Go to next message
sriram
Messages: 58
Registered: September 2000
Member
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?

Thanks

Sri
Re: Invoking Parallel query [message #74868 is a reply to message #74867] Sun, 03 August 2003 17:47 Go to previous message
rraghave
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: Thu Dec 09 01:03:25 CST 2021