Re: Index degree changed on all indexes to cpu_count on 10.2.0.4
From: Sayan Sergeevich Malakshinov <malakshinovss_at_psbank.ru>
Date: Thu, 24 Jan 2013 16:15:26 +0400
Message-ID: <OFD71295DE.F04AB57E-ON44257AFD.0041AF3B-44257AFD.00437DD3_at_psbank.ru>
Hi, Fred!
What about parallel degree on tables?
I would do this:
show parameter parallel;
alter system set parallel_max_servers=0; select
min(last_ddl_time),max(created)
from dba_objects o,dba_indexes i
where o.owner=i.owner
and o.object_name=i.index_name
and degree=8;
Date: Thu, 24 Jan 2013 16:15:26 +0400
Message-ID: <OFD71295DE.F04AB57E-ON44257AFD.0041AF3B-44257AFD.00437DD3_at_psbank.ru>
Hi, Fred!
What about parallel degree on tables?
I would do this:
show parameter parallel;
alter system set parallel_max_servers=0; select
min(last_ddl_time),max(created)
from dba_objects o,dba_indexes i
where o.owner=i.owner
and o.object_name=i.index_name
and degree=8;
checking audit for alter index % parallel, alter system %parallel%
Best regards,
Sayan Malakshinov
http://orasql.org
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 24 2013 - 13:15:26 CET