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;

checking audit for alter index % parallel, alter system %parallel%

Best regards,
Sayan Malakshinov
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 24 2013 - 13:15:26 CET

Original text of this message