بسم الله الرحمن الرحيم

اخواني الاعزاء اريد عمل rebuilt لجميع الindixes وهل لها اي تأثير سلبي على قاعدة البيانات .

الرجاااااااااااء مساعدتي في اقرب وقت ممكن

try this code
conn hr/hr
spool c:\index_reb.txt
select 'alter index '||index_name||' rebuild online tablespace indx;'
from user_indexes;
spool off

open file c:\index_reb.txt you will have a script to rebuild all indexes in your schema ,execute this script to rebuild them.after that try the select statment with another user .......
try use this script while users are not online
hope this will help you

THANK YOU VERY MUCH

حسناً ،،،،

ما رأيك بهذه التعليمة ،،

with INVOBJS_INDEPENDENT_INVOBJS as (
 select OBJECT_NAME, OBJECT_TYPE
 from USER_OBJECTS where STATUS = 'INVALID'
 minus 
 select d.NAME, d.TYPE
 from USER_DEPENDENCIES d, 
  (select OBJECT_NAME, OBJECT_TYPE from USER_OBJECTS where STATUS = 'INVALID') o
 where d.REFERENCED_NAME = o.OBJECT_NAME and d.REFERENCED_TYPE = o.OBJECT_TYPE)
select 
 'alter '||rpad(decode(OBJECT_TYPE,'PACKAGE BODY','PACKAGE',OBJECT_TYPE),14,' ')||
   rpad(OBJECT_NAME,31,' ')||'compile'||
   decode(OBJECT_TYPE,'PACKAGE BODY',' body')||';' COMPILE_COMMAND
from ( select 0 L, OBJECT_NAME, OBJECT_TYPE, NULL REFERENCED_NAME, NULL REFERENCED_TYPE
 from INVOBJS_INDEPENDENT_INVOBJS union all
 select LEVEL L, NAME, TYPE, REFERENCED_NAME, REFERENCED_TYPE
 from USER_DEPENDENCIES connect by prior NAME = REFERENCED_NAME and prior TYPE = REFERENCED_TYPE
 start with (REFERENCED_NAME, REFERENCED_TYPE) in (select OBJECT_NAME, OBJECT_TYPE from INVOBJS_INDEPENDENT_INVOBJS)) group by OBJECT_NAME,OBJECT_TYPE
order by max(L);

وبالتوفيق

بسم الله الرحمن الرحيم
starting from ooracle9i u can online rebuild indexes so that u can use the script give while user online and no performance problem