Re: Degree of Parallelism: 0?
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" [EMAIL PROTECTED] 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 -- -- -- --- SYSSYS_IL000261C2$$ KOTTD$ 0 SYSSYS_IL000265C2$$ KOTTB$ 0 SYSSYS_IL000269C2$$ KOTAD$ 0 SYSSYS_IL000273C2$$ KOTMD$ 0 SYSTEM SYS_IL002316C00012$$ AQ$_QUEUES 0 SYSTEM SYS_IL002462C00025$$ DEF$_AQCALL 0 SYSTEM SYS_IL002472C00025$$ DEF$_AQERROR 0 SYSTEM SYS_IL002490C5$$ DEF$_LOB 0 SYSTEM SYS_IL002490C4$$ DEF$_LOB 0 SYSTEM SYS_IL002490C3$$ DEF$_LOB 0 SYSTEM SYS_IL002499C3$$ DEF$_TEMP$LOB 0 SYSTEM SYS_IL002499C2$$ DEF$_TEMP$LOB 0 SYSTEM SYS_IL002499C1$$ DEF$_TEMP$LOB 0 SYSTEM SYS_IL003112C5$$ REPCAT$_TEMPLATE_OBJECTS 0 SYSTEM SYS_IL003125C4$$ REPCAT$_TEMPLATE_PARMS 0 SYSTEM SYS_IL003139C4$$ REPCAT$_USER_PARM_VALUES 0 SYSTEM SYS_IL003162C3$$ REPCAT$_RUNTIME_PARMS 0 CTXSYS SYS_IL076392C2$$ DR$STATS 0 QODE_APP SYS_IL014135C2$$ CREATE$JAVA$LOB$TABLE 0 SYSSYS_IL056091C3$$ AURORA$SNS$ATTRIBUTES$ 0 QODE_BCSYS_IL093690C6$$ DR$CTX_MFG_SEARCH$I0 QODE_BCSYS_IL093695C2$$ DR$CTX_MFG_SEARCH$R0 QODE_BCSYS_IL140689C6$$ DR$CTX_CAT_SEARCH$I0 QODE_BCSYS_IL140694C2$$ DR$CTX_CAT_SEARCH$R0 QODE_BCSYS_IL143153C6$$ DR$CTX_PRODUCT_SEARCH$I0 QODE_BCSYS_IL143158C2$$ DR$CTX_PRODUCT_SEARCH$R0 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Degree of Parallelism: 0?
Title: RE: Degree of Parallelism: 0? Hi Brian, thanks for your response. parallel_min_servers isn't set. Well I'm just not going to worry about it then, as long as it's not pinning my CPU's. Thanks Lisa -Original Message- From: Brian Wisniewski [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 7:35 AM To: Multiple recipients of list ORACLE-L Subject: Re: Degree of Parallelism: 0? 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 [EMAIL PROTECTED] 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, Im 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_IL000261C2$$ KOTTD$ 0 SYS SYS_IL000265C2$$ KOTTB$ 0 SYS SYS_IL000269C2$$ KOTAD$ 0 SYS SYS_IL000273C2$$ KOTMD$ 0 SYSTEM SYS_IL002316C00012$$ AQ$_QUEUES 0 SYSTEM SYS_IL002462C00025$$ DEF$_AQCALL 0 SYSTEM SYS_IL002472C00025$$ DEF$_AQERROR 0 SYSTEM SYS_IL002490C5$$ DEF$_LOB 0 SYSTEM SYS_IL002490C4$$ DEF$_LOB 0 SYSTEM SYS_IL002490C3$$ DEF$_LOB 0 SYSTEM SYS_IL002499C3$$ DEF$_TEMP$LOB 0 SYSTEM SYS_IL002499C2$$ DEF$_TEMP$LOB 0 SYSTEM SYS_IL002499C1$$ DEF$_TEMP$LOB 0 SYSTEM SYS_IL003112C5$$ REPCAT$_TEMPLATE_OBJECTS 0 SYSTEM SYS_IL003125C4$$ REPCAT$_TEMPLATE_PARMS 0 SYSTEM SYS_IL003139C4$$ REPCAT$_USER_PARM_VALUES 0 SYSTEM SYS_IL003162C3$$ REPCAT$_RUNTIME_PARMS 0 CTXSYS SYS_IL076392C2$$ DR$STATS 0 QODE_APP SYS_IL014135C2$$ CREATE$JAVA$LOB$TABLE 0 SYS SYS_IL056091C3$$ AURORA$SNS$ATTRIBUTES$ 0 QODE_BC SYS_IL093690C6$$ DR$CTX_MFG_SEARCH$I 0 QODE_BC SYS_IL093695C2$$ DR$CTX_MFG_SEARCH$R 0 QODE_BC SYS_IL140689C6$$ DR$CTX_CAT_SEARCH$I 0 QODE_BC SYS_IL140694C2$$ DR$CTX_CAT_SEARCH$R 0 QODE_BC SYS_IL143153C6$$ DR$CTX_PRODUCT_SEARCH$I 0 QODE_BC SYS_IL143158C2$$ 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Degree of Parallelism: 0?
Title: 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, Im 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_IL000261C2$$ KOTTD$ 0 SYS SYS_IL000265C2$$ KOTTB$ 0 SYS SYS_IL000269C2$$ KOTAD$ 0 SYS SYS_IL000273C2$$ KOTMD$ 0 SYSTEM SYS_IL002316C00012$$ AQ$_QUEUES 0 SYSTEM SYS_IL002462C00025$$ DEF$_AQCALL 0 SYSTEM SYS_IL002472C00025$$ DEF$_AQERROR 0 SYSTEM SYS_IL002490C5$$ DEF$_LOB 0 SYSTEM SYS_IL002490C4$$ DEF$_LOB 0 SYSTEM SYS_IL002490C3$$ DEF$_LOB 0 SYSTEM SYS_IL002499C3$$ DEF$_TEMP$LOB 0 SYSTEM SYS_IL002499C2$$ DEF$_TEMP$LOB 0 SYSTEM SYS_IL002499C1$$ DEF$_TEMP$LOB 0 SYSTEM SYS_IL003112C5$$ REPCAT$_TEMPLATE_OBJECTS 0 SYSTEM SYS_IL003125C4$$ REPCAT$_TEMPLATE_PARMS 0 SYSTEM SYS_IL003139C4$$ REPCAT$_USER_PARM_VALUES 0 SYSTEM SYS_IL003162C3$$ REPCAT$_RUNTIME_PARMS 0 CTXSYS SYS_IL076392C2$$ DR$STATS 0 QODE_APP SYS_IL014135C2$$ CREATE$JAVA$LOB$TABLE 0 SYS SYS_IL056091C3$$ AURORA$SNS$ATTRIBUTES$ 0 QODE_BC SYS_IL093690C6$$ DR$CTX_MFG_SEARCH$I 0 QODE_BC SYS_IL093695C2$$ DR$CTX_MFG_SEARCH$R 0 QODE_BC SYS_IL140689C6$$ DR$CTX_CAT_SEARCH$I 0 QODE_BC SYS_IL140694C2$$ DR$CTX_CAT_SEARCH$R 0 QODE_BC SYS_IL143153C6$$ DR$CTX_PRODUCT_SEARCH$I 0 QODE_BC SYS_IL143158C2$$ 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.