Home » Other » General » Database Maintenance Activities (Oracle 11g)
Database Maintenance Activities [message #478926] Wed, 13 October 2010 12:10 Go to next message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

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 messageGo to next message
Mahesh Rajendran
Messages: 10704
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
Michel Cadot
Messages: 68259
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
Previous Topic: Tables Structure (Normalization)
Next Topic: Base table info
Goto Forum:
  


Current Time: Sun Aug 14 11:34:38 CDT 2022