| Parallel Hint Question [message #109033] |
Mon, 21 February 2005 05:33  |
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
|
|
|
|
| Re: Parallel Hint Question [message #109460 is a reply to message #109033] |
Thu, 24 February 2005 16:39  |
Mack Sundar
Messages: 20
Registered: July 2002
|
Junior Member |
|
|
Unless you are operating on an extremely high transaction system, I would not worry about putting parallel hints on the query. Just apply the appropriate parameters in the INIT file and Oracle will decide to use the parallel capability.
I would worry more about how long Oracle is going to support 8i version.
|
|
|
|
| Re: Parallel Hint Question [message #110060 is a reply to message #109460] |
Thu, 03 March 2005 04:03 |
anmol1947
Messages: 34
Registered: February 2005
Location: Gurgaon
|
Member |
|
|
U can do like this
1.Include parllel hint in the queries written in procedures /function
2. alter the tables which are used in functions/procedurs
like
ALTER TABLE employees PARALLEL 4
ALTER Index abs .. PARALLEL 4
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
