| Parallel Hint Question [message #64648] |
Thu, 17 February 2005 21:36 |
bhagwan
Messages: 86
Registered: September 2004
|
Member |
|
|
Hi,
Iam an Oracle developer currently working on 8.1.7 version of Oracle.
I have come across a document which says Parallel hint works fine where
a) They Have multiple processors which will make the operation run even faster,
b)The table should be striped.
It says degree of parallelism and number of parallel servers is sourced from the parameters specified in the INIT.ORA file.
But as a developer if I want to use this Hint for DML operation in my stored procedure, how will I know
1) Degree of Parallelism or number of query servers for the table
2) Number of Oracle parallel server instances to split the query across.
3) Whether my datafiles is striped across multiple disks or not?
Is their any dictionary tables which can be queried?If so, Can I have that query with relevant explanation?
Regards,
Bhagwan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
