Administracja bazy danych Oracle 10g Training Course Outline

Architektura Oracle 10g

• Pamięć, procesy
• Instacja i bazy danych
• Struktura przechowywania danych
• Przetwarzanie zapytań

Instalacja bazy Oracle 10g

• Korzystanie z DBCA
• Sprawdzanie zainstalowanej bazy
• Rozwiązywanie problemów

Tworzenie bazy danych

• Konfigurowanie systemu operacyjnego
• Autentykacja kont uprzywilejowanych
• Tworzenie pliku parametrów
• Data dictionary management

Database Interfaces

• Using SQL*Plus and isql*Plus
• Accessing data and structure
• Using query, manipulation and transaction commands
• Creating, altering and dropping database information

Zatrzymywanie i uruchamianie bazy

• Starting processes - dbconsole, listener, isqlplus, database instance
• Startup modes
• Parameter file
• Alert log
• Shutdown operations

Przestrzenie tabel i pliki danych

• Purpose and use of tablespaces and datafiles
• Create, manage, drop tablespaces
• System tablespaces and user tablespaces
• Retrieving status information for tablespaces and datafiles

Obiekty schematu

• Creating and modifying tables
• Selecting appropriate data types
• Constraints
• Viewing table contents
• Creating and managing indexes and views
• Creating and using sequences

Undo Management

• Undo/rollback concepts
• Configure and size undo features
• Using the Undo Advisor
• Undo tablespaces
• Undo for transactions and rollback/recovery

Data Administration

• Moving data using DML
• Data Pump for export and import
• SQL Loader for importing external data
• Administering Oracle directories

Język PL/SQL dla administratorów

• PL/SQL Overview
• Anonymous blocks
• Procedures, functions, packages
• Triggers
• Supplied procedures

Zarządzanie użytkownikami

• Creating and managing user accounts
• Profiles, roles, privileges and user assignment
• User resource management

Bezpieczeństwo bazy danych

• Security principles
• Default user accounts
• Password management features
• Auditing database actions

Zarządzanie siecią

• Managing Oracle listener
• Net services
• Connect time failover
• Using Net Manager to configure resolution methods, database connectivity
• Configuring and administering shared servers

Backup and Recovery Concepts

• Overview of backup and recovery
• Failure point identification
• Configuring checkpoints, redo logs, archiving
• Configure database for recovery
• RMAN overview
• Flash recovery area

Database Backups

• Cold and hot datafile/tablespace backups
• Automated backups
• Incremental backups
• Image copies
• Multiplexed archive logs
• Control file backups
• Spfile/password file backups

Database Recoveries

• Restore and recovery overview
• Non-critical datafile recovery
• Critical file recovery
• Recovering damaged archive logs
• Recovering control files

Lock Management

• Detecting locking issues
• Transactions and locking
• Configuring optimum lock strategies
• Resolving potential deadlocks

Performance Guidelines

• Performance issues
• SQL optimiser statistics
• Gathering performance metrics
• Enterprise Manager performance features

Diagnostics and Tuning

• Setting automated alerts
• Collecting baseline metrics
• Using advisors
• Automatic Database Diagnostic Monitor
• Automated Workload Repository
• Responding to server alerts