|
Members heroes is good, often see people say ParallelDML can improve efficiency, but how to verify and do not open ParallelDML open ParallelDML the efficiency of the different? Normal circumstances, not to use the hint was killed by a parallel, but altertabletable_nameparallel enough. database, based on resources and other factors, the time to consider whether to use parallel QUOTE: The original quote by Mo Shang fine, issued in 2010-1-622:08 Under normal circumstances not to use the hint was killed by a parallel, but altertabletable_nameparallel enough. The database of resources and in accordance with the time to consider whether other factors associated with the parallel I saw the article can perform altersessionenableparallelquery; This is not the will of Kai to the same effect? But the key is verification. How do I view a table is enabled in parallel? And how to disable a table parallel? Also, I used setautoton, settimeon, but this information is changing, each time the results of the implementation is different. This how to do? Is there any testing program ah? I think it is / * parallel (x, 4) * / mode control After the oracle will be used to start the table all the resources to complete the contrary, you see the other affected under the tom's 9i(Editor：admin) |