مفاهیم پایه مدیریت پایگاه داده اوراکل(work shop I)

    Managing Data and Concurrency

( ) Monitor and resolve locking confilicts

Managing Undo Data

( ) Overview of Undo

( ) Transactions and undo data

( ) Managing undo

Implementing Oracle Database Security

( ) Database Security and Principle of Least

Privilege

( ) Work with Standard Database Auditing

Database Maintenance

( ) Use and manage optimizer statistics

( ) Use and manage Automatic Workload Repository(AWR)

( ) Use advisory framework

(  ) Manage Alerts and Thresholds

Performance Management

( ) Use Automatic Memory Management

( ) Use Memory Advisors

( ) Troubleshoot invalid and unusable objects

Intelligent Infrastructure Enhancements

( ) Use the Enterprise Manager Support

 Workbench

( ) Managing  Patches

Exploring the Oracle Database Architecture

( ) Explain the Memory Structures

( ) Describe the Process Structures

Overview Of Storage Structures ( )

Preparing the Database Environment

( ) Identify the tools For Administering an Oracle Database

( ) Plan an Oracle Database installation

( ) Install the Oracle software by using Oracle Universal Installer(OUI)

Creating an Oracle Database

( ) Create a database by using the Database Configuration Assistant (DBCA)

Managing the Oracle Instance

( ) Setting database initialization parameters

  ( ) Describe the stages of database startup and shutdown

( ) Using alert log and trace files

( ) Using data dictionary and dynamic performance views

Configuring the Oracle Network Environment

( ) Configure and Manage the Oracle Network

( ) Using the Oracle Shared Server architecture

Managing Database Storage Structures

( ) Overview Of tablespace and datafiles

( ) Create and manage tablespace

( ) Space management in tablespace

Administering User Security

( ) Create and manage Database user accounts

( ) Grant and revoke privileges

( )  Create and manage roles

( )  Create and manage profiles