Home » RDBMS Server » Performance Tuning » Parallel Hint Question
Parallel Hint Question [message #109033] Mon, 21 February 2005 05:33 Go to next message
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 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
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
Previous Topic: Indexes not working after analyzing tables
Next Topic: ORA-04030
Goto Forum:
  


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