Go BackOracle8: Processes and Security

Synopsis
Oracle8: Processes and Security explains server processes and discusses how to use Oracle security features.

Audience
This course is for anyone who is interested in learning about Oracle processes, job queues, and security monitoring in Oracle8.

Time
6 hours

Product Code: ORCC06
After completing Oracle8: Processes and Security, the user should be able to:
 
Export and import data using Export/Import
Load data using the SQL*Loader Utility
Describe the types of Oracle processes
Monitor Oracle processes
Manage Oracle job queues
Use Oracle Auditing for security monitoring

Exporting Data
 
The Export utility
The syntax for Export

Importing Data
 
The Import utility
The syntax for Import

The SQL*Loader Utility
 
The control file
Loading using Data Manager
Loading using the SQLLDR80 utility

Understanding Processes
 
Oracle8 process types
Dedicated vs. multithreaded server processes
Tuning the multithreaded server

Monitoring Processes
 
Using Task Manager
Using Performance Manager
Using Instance Manager
From the command line

Managing Job Queues
 
What is a job queue?
Scheduling jobs using Enterprise Manager

Using Oracle Auditing
 
The purpose of auditing
Developing an auditing strategy
Enabling the audit trail
Protecting the audit trail
Viewing audit information

This course is distributed with:
 
Exercises that allow users to practice in Oracle8.
A file containing the text of the exercises.
An Oracle8 glossary


 

Go Back