curiosity, mostly: default parallel degree clause

From: Dan Tow <dantow_at_singingsql.com>
Date: Thu, 13 May 2004 16:36:59 -0500
Message-ID: <1084484219.40a3ea7b18701@www.singingsql.com>

All,

I recently became aware that Oracle can have a DEGREE value (for example, for parallelism in DBA_INDEXES) of 'DEFAULT'. (To my embarrassment, this value makes one of my one-liner scripts in my book return an error, since it does not convert to a number.) You can achieve this value at index-creation time with the clause:

 parallel (DEGREE DEFAULT)

Have any of you ever actually used this? What's it good for?

Thanks,

Dan Tow
650-858-1557
www.singingsql.com

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu May 13 2004 - 18:35:49 CDT