Re: Unexpected Parallel Query Execution

• Post for FREE via your newsreader at post.usenet.com ****

Hi Matt

> Is there anyway that parallel query slaves would be used for a query
> when every table in the dayabase has a degree of 1 and no parallel
> hints have been used in the SQL.
>
> SQL> select distinct degree from dba_tables;
>
> DEGREE
> -------------------------------
> 1

I see only two possibilities:
1) DEGREE is set for some indexes
2) the statement ALTER SESSION FORCE PARALLEL {DML|DDL|QUERY} is used

Otherwise, are you really 100% sure that nobody has used a hint?

> The following output from v$session shows that parallel query was
> being used which ended up consuming the total server CPU capcacity:
>
> 3472 SYSTEM 20 26544 ORACLE.EXE (P000)
> 3492 SYSTEM 12 440 ORACLE.EXE (P001)
> 3476 SYSTEM 24 17751 ORACLE.EXE (P002)
> 3420 SYSTEM 22 37652 ORACLE.EXE (P003)
> 2396 SYSTEM 26 15038 ORACLE.EXE (P004)
> 3452 SYSADM COMMON\B89263 25 13709 SQLPLUSW.EXE
To have more information on the operation that was parallelized you can run the following query:

select name, value from v$sysstat where name like '%parallelized'

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=