oracle 全局并行,关于oracle并行操作parallel

查并行：

select *

from (select substr(owner, 1, 15) Owner,

substr(trim(degree), 1, 7) Degree,

substr(trim(instances), 1, 9) Instances,

count(*) "Num Indexes",

'Parallel'

from all_indexes

where (trim(degree) != '1' and trim(degree) != '0')

or (trim(instances) != '1' and trim(instances) != '0')

group by owner, degree, instances

union

select substr(owner, 1, 15) owner, '1', '1', count(*), 'Serial'

from all_indexes

where (trim(degree) = '1' or trim(degree) != '0')

and (trim(instances) != '1' or trim(instances) != '0')

and degree >1

group by owner)

order by owner;

或者

select owner,degree,index_name,index_type,table_name from all_indexes where degree >'1'

取消并行：

alter INDEX MPOS.IND_POP_STT noparallel;

select owner,degree,index_name,index_type,table_name from all_indexes where index_name='INDEX_NAME'

如果在创建索引的时候不使用并行之后没有对这个索引执行noparallel，在后续用到这个索引的时候会并行执行，浪费资源。所以如果创建索引使用的是并行操作的话，完事后取消并行。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30536096/viewspace-1978938/，如需转载，请注明出处，否则将追究法律责任。