Administracja bazy danych Oracle 10g XE

Zagadnienia omawiane na kursie

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