| Invoking Parallel query [message #74867] |
Tue, 15 July 2003 15:13  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
