Database Maintenance Activities [message #478926] |
Wed, 13 October 2010 12:10 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Hi,
Could anybody please let me know the Database Maintenance activities that would be carried out in a Production Support Project, I have identified the following activities,
1. Rebuilding Indexes
2. Avoiding/Preventing Row chaining
3. Gathering Statistics
4. Index Creation
5. Planned Database Backups
6. Checking Invalid objects
Please suggest whether the following can be considered as Maintenance activities or Monitoring
1. Disk space usage
2. Examine Logs
3. Average Session memory per user
4. No of users in Peak hours.
Regards,
Ashoka BL
|
|
|
Re: Database Maintenance Activities [message #478928 is a reply to message #478926] |
Wed, 13 October 2010 12:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/42800.jpg) |
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
>>1. Rebuilding Indexes
Very Very rarely. Definitely not as a scheduled job.
>> 3. Gathering Statistics
In most cases, Oracle's built-in job is sufficient.
In all cases, this is a scheduled job.
>> 4. Index Creation
Why would you create a new index in production "as maintenance activity"?
It should start atleast in your test env , ideally in development then be propagated to production.
>>5. Planned Database Backups
I usually never worry about backups, unless the database is very large without sufficient backup windows.
I am paranoid about restore/recovery, no matter what the size of database is.
>>Please suggest whether the following can be considered as Maintenance activities or Monitoring
Depends on your shop.
All these can be automated and results can be emailed to you.
[Updated on: Wed, 13 October 2010 12:30] Report message to a moderator
|
|
|
Re: Database Maintenance Activities [message #478931 is a reply to message #478928] |
Wed, 13 October 2010 12:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You are taking this at the wrong end.
The tasks are:
1/ Be sure the backupi are done without any error and can be restored. (this can be automated)
2/ Check AWR report if there is any drift in performances. (this can be automated)
3/ Support users on database errors and fix them
Statistics are automatically gathered by Oracle.
Invalid object are automatically recompiled.
Regards
Michel
|
|
|