مفاهیم پایه مدیریت پایگاه داده اوراکل(work shop I)
Oracle Workshop I:
Oracle Database Administrator Fundamental
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