CS 462

Assignment 3

Managing an Instance and Using Dynamic Performance Views

Out 2/4/2008, Due 2/11/2008

Objective(s):

1. To work with an Oracle instance

Turn in:

1. This sheet

2. Log of activities and output produced

1. Work with the installed Oracle

2. Start the instance in the nomount state.

3. What do the following V$ views do? Use them in any way to obtain information about the server

a. V$parameter

b. V$sga

c. V$option

d. V$process

e. V$session

f. V$version

g. V$instance

4. Use alter session to:

a. Flush the contents of the SGA shared pool.

b. Modify any two other options

5. Where is your alert file located? List some entries from it. Relocate the alert file to a different location?

Graduate Students

1. List all the default initialization parameters (parameters that have a default initial value).

2. List the maximum number of OS processes that can connect to the instance.