There are about 6-7 views whith %PQ% in their names that compile stats
about parallel executions.
If you want to trigger parallelism, you have to add the
optimizer_percent_parallel parameter to your init.ora
also alter every table and index parallel degree (7) for instance.
You can push further and alter the session parallel
If you want to witness parallelism, just switch on the "top sessions"
screen from oem tuning pack and look at your statement being processed
by a dozen extra sessions. It's great fun...
On Fri, 28 May 1999 11:58:02 GMT, tim_mcconechy_at_my-deja.com wrote:
>I'm new to Parallel Execution.
>
>What I want is to use the hints like..
>select /*+ PARALLEL(dbstruct,4) */ * from dbstruct where recno=1;
>
>The plan output says.
>SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=1 Bytes=100)
> TABLE ACCESS (BY INDEX ROWID) OF DBSTRUCT (Cost=2 Card=1 Bytes=100)
>INDEX (UNIQUE SCAN) OF DBSTRUCTIDX (UNIQUE) (Cost=1 Card=37)
>
>I was expecting it to say something about parallel.
>
>How can I know if it is using Parallel Execution ?
>
>
>I have seen chapter 22 but didn't find it in there?
>
>I am also confused about the fact that.
>Parallel execution is not the same as Oracle Parallel Server.
>I did not install Oracle Parallel Server.
>
>I am also not sure if Parallel Execution is enabled.
>
>Two questions are:
>1) How can I see if Parallel Execution is enabled, enable it???
>2) What should I see in plan output if it is?
>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon May 31 1999 - 16:08:17 CDT
