Managing Database Instances with Oracle

This course focuses exclusively on the Oracle instance. If you’ve been through the first course in this path, Understanding Database Architecture with Oracle, you’ll find some of the material in this course familiar.

In our fast-paced, digital, and information-driven world, an Organization’s data can be even more valuable than it’s tangible assets. It’s no surprise then that corporations tend to spare no expense when it comes to the preservation and day-to-day maintenance of their digital assets. In this course, Managing Database Instances with Oracle, you'll build upon what you’ve mastered in Understanding Database Architecture with Oracle. First, you'll start by reviewing what it means to STARTUP or SHUTDOWN an Oracle instance. Next, you’ll use the Automatic Diagnostic Repository (ADR) to access diagnostic information. After that, you’ll learn how to configure aspects of our Oracle system by setting and changing initialization parameters. Finally, you'l learn to mine the data dictionary for useful information. When you're finished with this course, you'll have the skills and knowledge necessary to work on the Oracle Instance.

• Course Overview 1min
• Starting and Stopping the Oracle Instance 8mins
• Using the Automatic Diagnostic Repository 7mins
• Managing Initialization Parameters 16mins
• Understanding the Data Dictionary 4mins