Home » RDBMS Server » Performance Tuning » Parallel Hint Question
Parallel Hint Question [message #109033] Mon, 21 February 2005 05:33 Go to next message
Messages: 86
Registered: September 2004
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?

Re: Parallel Hint Question [message #109460 is a reply to message #109033] Thu, 24 February 2005 16:39 Go to previous messageGo to next message
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 Go to previous message
Messages: 34
Registered: February 2005
Location: Gurgaon
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
ALTER Index abs .. PARALLEL 4
Previous Topic: Indexes not working after analyzing tables
Next Topic: ORA-04030
Goto Forum:

Current Time: Sun Feb 25 22:16:44 CST 2024