Re: About Parallel Option again.

Andres,
1. "Formal" setup - parallel_min_servers, parallel_max_servers. 2. To tell Oracle to use it:

• a. ALTER TABLE <table> PARALLEL (DEGREE n); This *enables" parallelism for this particular table, but does not enforce it.
• b. init.ora parameter: OPTIMIZER_PERCENT_PARALLEL=100 This will make parallel table scan "more attractive" for cost-based optimizer. 3. To force Oracle to use it:
• parallel hint in SELECT
• parallel clause in CREATE TABLE

However, you CANNOT force Oracle to use Cost-based optimizer for Pro*C executables like GLPPOS (posting- module name GLPMAI) or GLLEZL (Import - module name GLLMAI)
without changing init.ora OPTIMIZER_MODE (it should be set to RULE is per installation manual).
Oracle Applications is optimized for Rule-based optimization (both 10.7 and 11). Oracle Applications tables (like GL_CODE_COMBINATIONS, GL_BALANCES,
GL_DAILY_BALANCES, GL_JE_LINES, etc) are heavily indexed and index-based access is typically the best.
Probably, GL_CODE_COMBINATIONS is the only exception (depending on the nature of the query).

So you can use it in custom queries, and in Reports 2.5 reports, but not in concurrent programs, FSGs, etc.

Also, it works well only if your box is not CPU-bound.

Regards,
Vsevolod

P.S. Email me if you have any questions

andres wrote in message <7tc23m$2fk_at_dfw-ixnews3.ix.netcom.com>...
>Hi all:
>
>My company runs applications 10.7 on Oracle 7.3.4. Being that the case:
>Is the Parallel Option being used in the server?
> (I have checked that min_parallel_servers is = 0 and max is equal 5, and
>when the server manager
> starts it says Parallel Query option installed)
>
>Best regards,
>andres
>
>P.S: My question is based on the Idea that I do not have much control over
>non-customize applications (written directly by Oracle) so I can not
decide
>the parallelism when the table is created (Am I right or wrong about this?)
>
>
Received on Tue Oct 05 1999 - 07:18:27 CDT