Re: Seeing if there is Parallel Execution from tkptof output.

Maybe you did not succed in triggering parallelism. Other areas to watch are - your init.ora, did you write the "optimizer_percent_parrallel" parameter? - About 6 v$%PQ% views collect stats about parallel execution. You want to select * from them.
- OEM Top session will show you your SELECT dispatched among from 2 to 32+ different processes (but make it a bit longish or ooops) - There is indeed a way to witness parallelism in tkprof, I just used it last week, only I can't remember if I took the hints from "Burleson Oracle 8 tuning" or the original Oracle paper doc. - Try "Alter session enable parallel DML" By the way, anyone hates the new HTML doc in V8 more than me??? Please rate this list from botom to topless: Oracle GLue
Oracle Doc in Book format
Oracle Doc in Help Format
Oracle Doc in pdf format
Oracle Doc in Html format
Virginia Principal in Wet T-Shirt Night (She surely triggers parallelism :-) )

I shrivel - shrink - shiver at the thought of the next time I'll be on a production station and the ORA-1453 call will ring and I'll have to search for the message!!! Good Grief, does Larry take us for Charlie Browns????

On Mon, 31 May 1999 08:45:17 GMT, tim_mcconechy_at_my-deja.com wrote:

>I'm not sure what you mean... But say I have a query.
>************************************************************************
>********
>
>select /*+ PARALLEL(dbstruct,4) */ *
>from
> dbstruct where recno=1
>
>
>call count cpu elapsed disk query current
>rows
>------- ------ -------- ---------- ---------- ---------- ----------
>----------
>Parse 3 0.00 0.00 0 0 0
>0
>Execute 3 0.00 0.00 0 0 0
>0
>Fetch 6 0.00 0.00 1 9 0
>3
>------- ------ -------- ---------- ---------- ---------- ----------
>----------
>total 12 0.00 0.00 1 9 0
>3
>
>Misses in library cache during parse: 1
>Optimizer goal: CHOOSE
>Parsing user id: 19 (SYSADM)
>
>Rows Execution Plan
>------- ---------------------------------------------------
> 0 SELECT STATEMENT GOAL: CHOOSE
> 1 TABLE ACCESS (BY INDEX ROWID) OF 'DBSTRUCT'
> 1 INDEX (UNIQUE SCAN) OF 'DBSTRUCTIDX' (UNIQUE)
>
>************************************************************************
>********
>
>As apposed to:
>
>************************************************************************
>********
>
>select *
>from
> dbstruct where recno=1
>
>
>call count cpu elapsed disk query current
>rows
>------- ------ -------- ---------- ---------- ---------- ----------
>----------
>Parse 1 0.00 0.00 0 0 0
>0
>Execute 1 0.00 0.00 0 0 0
>0
>Fetch 2 0.00 0.00 0 3 0
>1
>------- ------ -------- ---------- ---------- ---------- ----------
>----------
>total 4 0.00 0.00 0 3 0
>1
>
>Misses in library cache during parse: 1
>Optimizer goal: CHOOSE
>Parsing user id: 19 (SYSADM)
>
>Rows Execution Plan
>------- ---------------------------------------------------
> 0 SELECT STATEMENT GOAL: CHOOSE
> 1 TABLE ACCESS (BY INDEX ROWID) OF 'DBSTRUCT'
> 1 INDEX (UNIQUE SCAN) OF 'DBSTRUCTIDX' (UNIQUE)
>
>
>
>
>************************************************************************
>********
>
>
>See there is no difference.
>What should I see if parallel exuction is working.
>
>
>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:06 CDT