Welcome! Wikis are websites that everyone can build together. It's easy!

Administration

Database Administration includes the following tasks:

Each database requires at least one database administrator (DBA) to administer it. Because an Oracle database system can be large and can have many users, often this is not a one person job. In such cases, there is a group of DBAs who share responsibility. A database administrator's responsibilities can include the following tasks:
  • Installing and upgrading the Oracle server and application tools
  • Allocating system storage and planning future storage requirements for the database system
  • Creating primary database storage structures (tablespaces) after application developers have designed an application
  • Creating primary objects (tables, views, indexes) once application developers have designed an application
  • Modifying the database structure, as necessary, from information given by application developers
  • Enrolling users and maintaining system security
  • Ensuring compliance with your Oracle license agreement
  • Controlling and monitoring user access to the database
  • Monitoring and optimizing the performance of the database
  • Planning for backup and recovery of database information
  • Maintaining archived data on tape
  • Backing up and restoring the database
  • Contacting Oracle Corporation for technical support


Latest page update: made by HelioDias , Nov 30 2007, 12:36 PM EST (about this update About This Update HelioDias Link to ADMIN - HelioDias


view changes

- complete history)
More Info: links to this page

Anonymous  (Get credit for your thread)


Started By Thread Subject Replies Last Post
mcgg monitoring index usage 2 Jun 25 2008, 7:09 AM EDT by mcgg
mcgg
Thread started: Jun 24 2008, 3:41 AM EDT  Watch
Hi all, can you tell me something about this?
I'd like to know what happens when you execute:
alter index i1 monitoring/nomonitoring usage;
I mean, is there some effect on the queries and cursors that are in the SGA? Do they have to be reparsed again, as it happens when you rebuild an index? Are they flushed from SGA?
And, is there any other thing to take into account?
thank you very much
1  out of 1 found this valuable. Do you?    
Show Last Reply
tmbeetz rman 11g and other database 10g 3 May 5 2008, 12:16 AM EDT by monowar94ru
Thread started: Feb 6 2008, 9:12 AM EST  Watch
Hello,

can i use rman 11g to backup an database version 10.2.0.3 ?

thnaks
thomas
0  out of 4 found this valuable. Do you?    
Show Last Reply
pappu98 installing Oracle 11g enterprise... 1 Apr 12 2008, 8:39 AM EDT by hostrow
Thread started: Apr 8 2008, 6:54 AM EDT  Watch
Hello guys, I really need some help here
I have been given a task of Installing oracle 10g or 11g on a windows 2003 server R2 which will be the main host server. currently we have oracle 9i on sun solaris. I want to know that which version should I download and how should I install it. Is there any documentation available for it.

Thank u.
0  out of 1 found this valuable. Do you?    
Show Last Reply
HelioDias 9i, 10g, 11g Memory management 0 Nov 30 2007, 12:14 PM EST by HelioDias
HelioDias
Thread started: Nov 30 2007, 12:14 PM EST  Watch
On 9i Oracle release pga_target.
On 10g Oracle release sga_target.
On 11g we have the complete memory management with memory_target.
16  out of 20 found this valuable. Do you?    

Related Content

(what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Top Contributors