Lesson Three - Managing an Oracle Instance

08/15/1999


Click here to start


Table of Contents

Managing an Oracle Instance

Objectives

PPT Slide

Database Administrator Users .

User SYS and SYSTEM

Authentication Methods

Operating System Authentication

Using Password File Authentication

Changing the Internal Password

The Initialization Parameter File

Parameter File Example

Startup and Shutdown in Stages

STARTUP Command

Shutdown Options

Shutdown Time

Dynamic Performance Views

Accessing Dynamic Performance Views

Example

Displaying Current .Parameter Values

Dynamic Initialization Parameters

Enable and Disable .Restricted Session

Terminating Sessions

Trace Files

Controlling the Trace File

Guidelines

Summary

Author: Julie Rose

Email: melody@ecst.csuchico.edu

Home Page: http://www.ecst.csuchico.edu/~melody

Download presentation source