Leave a Comment:
8 comments
Hello Saurabh,
Very good post on Indexes. Can you also please let us know how to confirm what are the indexes needs to be rebuild.
Ramam
ReplyHi surabh,
Please provide information on how to identify the large and fragmented indexes and also let us know how to configure oracle alert to get notifications.
Thanks,
Venu
Hi Ramam,
Thanks for you appreciation.
The script is capable to analyze and select the indexes which requires rebuild. These indexes are reported in stats file BDE_REBUILD_REPORT.TXT, which is generated when you run the script. The parameter ‘Threshold’ takes care of this. Threshold represents the Amount of unused space due to deletes. You can enter Threshold value between 20-80, for OLTP env 50 is ok.
Regards,
Saurabh
Hi Venu,
The script will automatically identify the indexes need to be rebuild. You only have to specify the Threshold parameter while running the script. If your env is OLTP then you can rely on default value of Threshold which is 50.
You can configure alert.
navigate to alert manager resp> define
query by name ‘Indexes too large or fragmented’.
check the enable box. Now click the Actions button. select ‘summary message to DBA’, then click action details. Specify your email id in ‘To’ box and save.
Now you can run this request from
alert manager > request > check
or you can schdule this alert. please note you have to configure mailer notification to recieve mails.
hi Saurabh,
Very good post on Indexes,can you throw some light on large or fragmented table in 11i .
regards
sanjeev
Hi Sanjeev,
Thanks for your good words.
I ‘ll try to work on your suggestion as soon as possible.
Regards,
Saurabh