Lisa, are the servers actually running or are the idle? If you have
parallel_min_servers set to something other than 0 then you will still
see the servers in v$pq_sysstat they will just remain idle.
I'm not sure about the degree 0, I was thinking it was the same as 1
(no parallelism) but I tried setting it in 8.1.7 and 8.0.5.2.1 to 0 and
I received an error message.
- Brian
- "Koivu, Lisa" <lkoivu_at_qode.com> wrote:
> Hello all,
>
> I've purposely got PQO off. But I was shocked to see I've got some
> parallel
> query slaves out there. I checked to see which objects they are,
> listed
> below. I'm not concerned about the sys/system stuff, I"m worried
> about CTX
> (my intermedia text stuff.) Can anyone tell me exactly what DEGREE =
> 0 is??
> I don't see it in the doco.
>
> Thanks
>
>
> 1 select owner, index_name, table_name, degree
> 2 from dba_indexes
> 3* where degree <> 1
> SQL> /
>
> OWNER INDEX_NAME
> TABLE_NAME
> DEGREE
> ------------------------------ ------------------------------
> ------------------------------ -------
> SYS SYS_IL0000000261C00002$$ KOTTD$
> 0
> SYS SYS_IL0000000265C00002$$ KOTTB$
> 0
> SYS SYS_IL0000000269C00002$$ KOTAD$
> 0
> SYS SYS_IL0000000273C00002$$ KOTMD$
> 0
> SYSTEM SYS_IL0000002316C00012$$
> AQ$_QUEUES
> 0
> SYSTEM SYS_IL0000002462C00025$$
> DEF$_AQCALL
> 0
> SYSTEM SYS_IL0000002472C00025$$
> DEF$_AQERROR
> 0
> SYSTEM SYS_IL0000002490C00005$$
> DEF$_LOB
> 0
> SYSTEM SYS_IL0000002490C00004$$
> DEF$_LOB
> 0
> SYSTEM SYS_IL0000002490C00003$$
> DEF$_LOB
> 0
> SYSTEM SYS_IL0000002499C00003$$
> DEF$_TEMP$LOB
> 0
> SYSTEM SYS_IL0000002499C00002$$
> DEF$_TEMP$LOB
> 0
> SYSTEM SYS_IL0000002499C00001$$
> DEF$_TEMP$LOB
> 0
> SYSTEM SYS_IL0000003112C00005$$
> REPCAT$_TEMPLATE_OBJECTS 0
> SYSTEM SYS_IL0000003125C00004$$
> REPCAT$_TEMPLATE_PARMS 0
> SYSTEM SYS_IL0000003139C00004$$
> REPCAT$_USER_PARM_VALUES 0
> SYSTEM SYS_IL0000003162C00003$$
> REPCAT$_RUNTIME_PARMS 0
> CTXSYS SYS_IL0000076392C00002$$
> DR$STATS
> 0
> QODE_APP SYS_IL0000014135C00002$$
> CREATE$JAVA$LOB$TABLE 0
> SYS SYS_IL0000056091C00003$$
> AURORA$SNS$ATTRIBUTES$ 0
> QODE_BC SYS_IL0000093690C00006$$
> DR$CTX_MFG_SEARCH$I 0
> QODE_BC SYS_IL0000093695C00002$$
> DR$CTX_MFG_SEARCH$R 0
> QODE_BC SYS_IL0000140689C00006$$
> DR$CTX_CAT_SEARCH$I 0
> QODE_BC SYS_IL0000140694C00002$$
> DR$CTX_CAT_SEARCH$R 0
> QODE_BC SYS_IL0000143153C00006$$
> DR$CTX_PRODUCT_SEARCH$I 0
> QODE_BC SYS_IL0000143158C00002$$
> DR$CTX_PRODUCT_SEARCH$R 0
>
> 26 rows selected.
>
> SQL>
>
> 26 rows selected.
>
> Lisa Rutland Koivu
> Oracle Database Administrator
> Qode.com
> 4850 North State Road 7
> Suite G104
> Fort Lauderdale, FL 33319
>
> V: 954.484.3191, x174
> F: 954.484.2933
> C: 954.658.5849
> http://www.qode.com
>
> "The information contained herein does not express the opinion or
> position
> of Qode.com and cannot be attributed to or made binding upon
> Qode.com."
>
>
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Brian Wisniewski
INET: brian_wisniewski_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Feb 14 2001 - 07:24:03 CST
