Overview

Introduction

The Oracle Database Instances module provides you with the instructions and devices to develop your hands-on skills in the following topics.

  • Understand Initialization Parameter Files
  • Understand how to Start Up and Shutting Down an Oracle Instance
  • View the alert logs and access dynamic performance view

Exercise 1 - Understanding Initialization Parameter Files

In this exercise, you will:

  • Establish a connection to the database using SQL*Plus
  • Display Database Parameters
  • Learn the difference between V$PARAMETER and V$SPPARAMETER
  • Change parameter values

Exercise 2 - Starting Up and Shutting Down an Oracle Instance

In this exercise you will learn:

  • How to start an Oracle database instance
  • How shutdown an Oracle database Instance

Exercise 3 - Viewing the Alert Logs and Access Dynamic Performance View

Oracle contains a set of views that are maintained by the database server and are accessible to the database administrator user SYS.

In this exercise you will:

  • Understand the dynamic performance view
  • The data in these views is continuously updated while a database is in use and relates primarily to performance and hence the view is called dynamic performance view.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.