:Objective
At the end of the course delegates will be able to create and manage database users, implement a security system to control their activities, define a backup strategy and perform recovery in the event of a system failure and tune the database to optimize performance.
Knowledge of the target operating system is helpful. Delegates should also be competent in the skills covered by the PTR Oracle SQL*Plus Fundamentals course.
:Course outline
Introduction .. Oracle System Architecture
Overview of components, processes and functions of Oracle 8
Data files, redo logs, control files, parameter file
System Global Area and shared memory structures
Description of Administrator facilities and duties
Creating a database
Setting initialization parameters - Important SQL scripts
Starting up, mounting and opening the database
Shutdown modes - Using the data dictionary
Managing and optimizing disk space
The System table space - Creating additional table spaces
Important storage parameters - Monitoring extents and free space
Extending table spaces - Configuring rollback segments
Configuring redo logs
Tables and indexes .. Performance issues
Storage parameters and PCTFREE and PCTUSED
Oracle 8’s new partitioning facilities
Partitioning tables - Partitioning indexes
Managing partitions - Oracle 8 and objects
Tuning memory structures
Monitoring shared memory - Sizing the buffer cache
shared pool and redo log buffer - Tuning sort operations
User administration
Creating users - Using Oracle 8’s new password controls
Default and temporary table spaces
Space quotas - Profiles
System and object privileges
Creating and managing roles
System and object auditing
Backup & recovery .. Archiving redo logs
Hot and cold database backups - Instance recovery
Database, table space and data file recovery (practical exercise)
The Oracle 8 Recovery Manager
Oracle Utilities .. Export and import - SQL Loader