Turn in

1. This sheet

2. Your report

1. Assume a new DBA comes to you with the following question: “I’d like to have two instances running (say s1 and s2) on the same machine. Clients will use sql*plus to connect to these instances. How can I achieve this? Please assume that I know nothing beyond the notion of an instance”. Help this new DBA.

2. Explain in as much detail as you can at least 6 parameters found in a typical init.ora file. You may refer to the orafaq.com web site accessible through the class homepage for your research.

3. When you start an instance in the nomount state, Oracle shows you some values. Explain that output: what those values mean.

4. Starting with Oracle 8i, a new scheme is used to reference an Oracle instance: service name (instead of an instance name or SID). What is this service name and how is it related to the instance name?

Graduate Students

1. Starting with Oracle 9i, the SGA includes a few more caches than those discussed in class: Keep Buffer Cache, Recycle Buffer Cache, and Variable Block Cache. Explain these and their roles.

2. Explain the clustering option in Oracle 10g.