| Database Maintenance Activities [message #478926] |
Wed, 13 October 2010 12:10  |
|
|
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  |
 |
Mahesh Rajendran
Messages: 10708
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 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
