ORACLE DATABASE ADMINISTRATION / 15-Sep-2006 Page 1 of 1
Activity: Curriculum development Participants: Bil Bergin
Action: Added Modified Delete Accepted Not Reviewed Deactivate
P
ROGRAMD
EACTIVATEDRational: Evaluated Oracle Database Operations program as part of the SLO assessment activity. As a result,
this program is being redesigned to focus on current and emerging database technologies. As it is presently configured, we are constrained to a single vendor (Oracle) technology, and do not have the opportunity to address other technologies and innovations in the database world. New program developed: Database Administration
ORACLE DATABASE ADMINISTRATION / 28-Apr-2005 Page 1 of 2
S
ETTINGActivity: CIS Department Meeting
Participants: Ron Bowman, Mark Dumas, Don Jenkins, Dottie Smith, Ted Tielens, Ric Williams, Bil Bergin
Action: Added Modified Delete Accepted Not Reviewed
P
ROGRAMM
ATRIX241B 251B 261B 271B
Describe the general responsibilities, and list the typical day-to-day
activities of a Database Administrator.
Describe the logical and physical architectural elements of an Oracledatabase.
Plan for, install, and create an operational database.
Start up and shutdown an Oracle instance and database.
Manage data files.
Manage tablespaces, segments, extents and blocks.
Manage users, privileges and resources.
Describe the general responsibilities, and list the typical day-to-day
activities of a Database Administrator.
List and describe the key issues in defining an effective backup and
recovery strategy.
List and describe the Oracle architecture components related to
backup and recovery operations.
Set up and perform a logical backup and recovery for an Oracle
database.
Set up and perform a physical backup and recovery of an Oracle
database.
Diagnose and troubleshoot database problems and failures.
Configure a standby database.
Implement different types of backup methods using Oracle database
tools.
Describe the characteristics of distributed database environments.
Evaluate the potential risks and advantages associated with distributed
databases.
Identify network security risks and their solutions.
Define the Net8 architectural layers.
Configure a simple client and server, and establish a connection
between them.
Configure a Names server and use it to resolve a service name.
Analyze and troubleshoot Net8 problems using log files, trace files andTrace Assistant.
List the options to enhance performance tuning requirements for
different types of applications.
Collect performance statistics.
Program Learning Outcome Package Oracle Database Administration Page 2 of 5
ORACLE DATABASE ADMINISTRATION / 28-Apr-2005 Page 2 of 2 Evaluate and resolve I/O, data storage and database configuration
ORACLE DATABASE ADMINISTRATION / 07-Apr-2005 Page 1 of 2
S
ETTINGActivity: Acquired from CIS Program Review developed 2004-2005 Participants: Bil Bergin
P
ROGRAMM
ATRIX241B 251B 261B 271B
Describe the general responsibilities, and list the typical day-to-day
activities of a Database Administrator.
Describe the logical and physical architectural elements of an Oracledatabase.
Plan for, install, and create an operational database.
Start up and shutdown an Oracle instance and database.
Manage data files.
Manage tablespaces, segments, extents and blocks.
Manage users, privileges and resources.
Describe the general responsibilities, and list the typical day-to-dayactivities of a Database Administrator.
List and describe the key issues in defining an effective backup and
recovery strategy.
List and describe the Oracle architecture components related to
backup and recovery operations.
Set up and perform a logical backup and recovery for an Oracle
database.
Set up and perform a physical backup and recovery of an Oracle
database.
Diagnose and troubleshoot database problems and failures.
Configure a standby database.
Implement different types of backup methods using Oracle database
tools.
Describe the characteristics of distributed database environments.
Evaluate the potential risks and advantages associated with distributeddatabases.
Identify network security risks and their solutions.
Define the Net8 architectural layers.
Configure a simple client and server, and establish a connection
between them.
Configure a Names server and use it to resolve a service name.
Analyze and troubleshoot Net8 problems using log files, trace files andTrace Assistant.
List the options to enhance performance tuning requirements for
different types of applications.
Collect performance statistics.
Use Oracle tools to diagnose performance problems.
Configure memory and disk resources to optimize sort operations.
Program Learning Outcome Package Oracle Database Administration Page 4 of 5
ORACLE DATABASE ADMINISTRATION / 07-Apr-2005 Page 2 of 2
