ORACLE : Shell script to rebuild indexes for index fragmentation

Share via:
Shell script to rebuild indexes for index fragmentation

Dear Readers,

In this article , we wrote a automation job for rebuild indexes for index fragmentation.

Note :

1) Please test the Shell script in Non-Prod before implementing it in Production.
2) Make sure you implement shell script during Application Downtime
3) Make sure no blocking sessions during the execution of the script.

Script for rebuild indexes for index fragmentation.

Please use below files for above shell scripts .  

index_rebuild_check

Index_rebuild_Auto_2

index_rebuild_check

Output :

We can automate same job in Crontab :

 

Thank you for giving your valuable time to read the above information.
Follow us on 
Website  www.ktexperts.com
Facebook Page KTExperts Facebook
Linkedin Page : KT EXPERTS Linkedin

 

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Add Comment