Parallel Execution Help.

From: <tim_mcconechy_at_my-deja.com>
Date: Fri, 28 May 1999 11:58:02 GMT
Message-ID: <7im0c9$dcu$1@nnrp1.deja.com>

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 Fri May 28 1999 - 06:58:02 CDT