| |
Basic Oracle Database Database Administration
Assumptions and pre-requisites
Delegates have some experience of using Oracle.
Course Outline
What is Oracle?
- Product description and functionality available
- Personal, Standard, Enterprise
- Where to obtain information (release notes, web sites and Metalink)
- Installation considerations
- Issues when creating a new database
- location of files
- position of database server computer in the network
- database name
- instance name
Oracle Architecture
- INSTANCE
- DATABASE
- Key Operating System files
- Where data is stored
- TWO-TASK Dedicated Server
- Multi-threaded server
Data Storage
- Tablespaces
- Segments
- Extents
- Blocks
- Setting defaults
- Overriding defaults
Tuning Storage patterns
- Extent sizes
- Block Sizes
- Use of PCTFREE
- Use of PCTUSED
- Identifying and dealing with chained rows
Database health check
- Watching the growth of the System tablespace
- Reviewing information in the Data Dictionary
- Key locking contention areas:
- disk IO
- blocks
- rollback segments
- Tuning the SGA
- block buffers
- redo buffer
- Tuning the PGA
- Considering the differences between MTS and DS
- Setting PGA parameters optimally
Considering the NLS parameters
- NLS_DATE_FORMAT and timestamp parameters
- NLS_CURRENCY
- The character format parameters
Introduction to setting up and using NET*8
- SQLNET.ORA
- LISTENER.ORA
- TNSNAMES.ORA
- Names Server
- Oracle's LDAP interface
- The password file
A review of the Oracle Backup and Recovery techniques
- Full cold backup with restore/recovery options
- ARCHIVE LOG MODE
- Offline and online tablespace backup
- Restore and recovery of a tablespace
- Using EXPORT and IMPORT
- Automating the "manual" scripts via SQL*Plus
- An introduction to RMAN
- Full consistent online backup of the database
- Incremental backups
- Automating the backup, restore, and recovery
- Other techniques for truly 24X7 databases
- Brief overview of Standby database used for backups
- Using logminer and flashback queries
An introduction to using the OEM tools
- Instance, Schema, Security, and Storage management
- Diagnostics Pack
- Tuning Pack
- Index Tuning Wizard
- Oracle expert
- SQL Analyze
[RETURN TO LIST OF COURSES]
|