|
Hi, Is there any way, we can know that, the parallelism is set or enabled on a table. Thanks, Regards, BI DWH BALA
(comments are locked)
|
|
SELECT TABLE_NAME, DEGREE FROM USER_TABLES WHERE TABLE_NAME='YOUR_TABLE_NAME'; I encourage you to get familiar with the Oracle documentation on Application Development so you can get the most out of Parallel Processing. The 10g Oracle Database Warehousing guide has a chapter on Using Parallel Execution here: link Another helpful page is the Catalog Views / Dictionary Views reference. This is only partially correct. You also need to look at the instances column, as the statement might be running on more than one instance in case of RAC. In addition this only describes the default parallelism. In addition parallelism can also be specified as hints to the SQL statement.
Nov 24 '09 at 04:01 PM
user-74
(comments are locked)
|

