AdministrationThis is a featured page

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


HelioDias
HelioDias
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
Started By Thread Subject Replies Last Post
varun_parashar1983 hai this is egarding the lost password. 0 Thursday, 11:34 PM EST by varun_parashar1983
Thread started: Thursday, 11:34 PM EST  Watch
hey for my crystal report server i am using oracle 9i as a back end but i forget the admnistrative password of the crystal report and i dont even have any other user to log into the crystal report.I have the administrative rights for the application so i want to know is there any other way to reset the password or create a new user from the backend database.
Do you find this valuable?    
mcgg monitoring index usage 2 Jun 25 2008, 7:09 AM EDT by 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
Showing 3 of 5 threads for this page - view all

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.)