Home > DBA's day, Definitions, oracle > DBA Tasks

DBA Tasks


We can separate the dba tasks between daily, weekly and monthly procedures:

Daily
– Verify instance status
– Check alerts
– Check configured metrics
– Check RMAN backups
– Check storage
– Check CPU contention
– Check waiting times
– Check memory usage
– Check network load
– Check iostat

Weekly

– Invalid objects
– Tunning: indexes and execution plans
– Top SQL
– Environments consistence
– Review of ressource policy
– Trends and peaks
– Cleaning of alert logs
– Review of RMAN

Monthly

– Recovery tests
– Analyze the data increment trend
– Tunning
– Review I/O
– Fragmentation
– Row chaining
– High Availability Analysis
– Scalability
– Schedule monthly downtime

Advertisements
  1. venkat
    August 14, 2011 at 4:39 am

    thanku so much , if u r having the real time senarios , plz forward to me.

  2. nanda
    June 21, 2012 at 10:59 am

    hai very good information about this

  3. avinash
    October 15, 2012 at 3:54 am

    thank u for giving this type of benefits to us….one request to u can u send the real time scenarios to my mail id ladi.avinash88@gmail.com

  4. April 29, 2013 at 10:13 am

    thank u for giving this type of benefits to us….one request to u can u send the real time scenarios to my mail id kalyan.r123@gmail.com

  5. raj
    May 11, 2013 at 4:45 pm

    thank you so much and if you have any more like this could u plese send any real time scenarios to this mail grgrard@gmail.com
    thanks and regrds

  6. vinod
    April 24, 2014 at 6:45 am

    thank you ,you have any more realtime scenarios and useful docs plz forward my mail:vinod.944@gmail.com

  7. Sid
    November 27, 2014 at 5:32 am

    Will you elaborate on “how” you do these tasks? That would be very helpful.

    Thank you.
    Sid

  8. prabha
    December 2, 2014 at 8:47 am

    thank you,if you have real time scenarios plz forward tom me prabhakardba@yahoo.com,adversely thank you once again.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: