Re: Index degree changed on all indexes to cpu_count on

From: Sayan Sergeevich Malakshinov <>
Date: Thu, 24 Jan 2013 16:15:26 +0400
Message-ID: <>

Hi, Fred!
What about parallel degree on tables?
I would do this:
show parameter parallel;
alter system set parallel_max_servers=0; select
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

Received on Thu Jan 24 2013 - 13:15:26 CET

Original text of this message