Solved

WHAT ARE THE TASK PRODUCTION SUPPORT DBA  DOES....

Posted on 2008-10-11
4
749 Views
Last Modified: 2013-12-18
what are the task does production support dba does?
0
Comment
Question by:dbaseek
  • 2
4 Comments
 
LVL 11

Expert Comment

by:jgiordano
ID: 22695783
A production DBA will do the following; all are dependent upon size f organization and maybe split into jr. sr. tasks:

Install database
Backup database
analyze database
perform maintenance (resizing of allocated space, adding space, distribution of rollback segment use)
Performance analysis
patching database
upgrading database
creating/administering users, db_links, security and all objects sucha as (tables, indexes, views etc...)
reviewing code developers want to deploy to databases

Are you looking for more detail into some of these tasks?
0
 

Author Comment

by:dbaseek
ID: 22695953
more like health checks daily activities..
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 22696678
it looks you forgot that you asked this kind of question(s) already 10 months ago:
http://www.experts-exchange.com/Database/Oracle/Q_22114309.html

are you running in circles? any progress?

also, please do NOT fall back into your BAD habit of posting with the CAPS LOCK turned on.
0
 

Author Comment

by:dbaseek
ID: 22698537
WONDER FUL THANKS
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Bulk insert into global temporary table 2 58
performance tunning sql insert - challenging one 2 42
Encryption Decryption in Oracle 12 102
Dataware house query tuning 9 62
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now