I would like to ask as a DBA , if there is any standard scripts available for oracle that we can run weekly which can rebuild indexes, update the statistics or enhance performance?
Thank you very much
Edited by: user562674 on Feb 14, 2013 5:57 AM
You are typically starting - by asking wrong questions - an endless thread.
Rebuilding index on regular basis ? Discussed thousands of time here.
Update stats ? What version are you working on ? Discussed thousands of time here.
Enhance performance ? There's nothing to prevent future performance issue.
There's a nice tool though, OEM Grid Control which help a lot in many ways for the DBA tasks.