Degree of Parallelism: 0?

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

"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." Received on Tue Feb 13 2001 - 18:32:38 CST