Already a member?
Sign in
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
Link to ADMIN
- HelioDias
view changes
- complete history)
Link to ADMIN
- HelioDias
view changes
- complete history)
Keyword tags:
Database Administration DBA
More Info: links to this page
| Started By | Thread Subject | Replies | Last Post | |
|---|---|---|---|---|
| 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?
Keyword tags:
Database Administration DBA
|
|||
| 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?
Keyword tags:
Database Administration DBA
|
||||
| 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?
Keyword tags:
Database Administration DBA
|
||||
| HelioDias | 9i, 10g, 11g Memory management | 0 | Nov 30 2007, 12:14 PM EST by 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?
Keyword tags:
Database Administration DBA
|
|||
