CS462 Oracle Database Administration

Assignment 4

Managing a Database

Out 4/25/2005, Due 5/2/2005

Objective(s):

1. To understand the concepts surrounding an Oracle database

Turn in:

1. This sheet

2. Log of activities and output produced

3. Other answers

1. What do the commands ALTER SYSTEM and ALTER SESSION do? List some parameters that can be modified with the above commands and implement that.

2. Start with the pfile in the UserManaged folder. Then

a. Create a sp file from it and place it in the appropriate folder

b. Create a database using the spfile

c. Confirm that Oracle is using the spfile

d. Create a pfile from the spfile and compare the two pfiles

3. Use dynamic performance views to:

a. List all tables available to users SYS and SYSTEM (USER_TABLES)

b. Using DBA_USERS view, list all users in the database.

c. List the number and locations of existing log files.

d. List the name and locations of the control file(s)

Graduate Students

1. Explain the following buffers in the SGA – what purpose do they serve and their relationship to db_cache_size?

Shared_pool_size, db_cache_size, db_keep_cache_size, db_recycle_cache_size, db_nk_cache_size where n=2,4,8,16,32

2. Explain the ISSES_MODIFIABLE and ISSYS_MODIFIABLE parameters and use them in an example.