Managing a Database Instance
Oracle 12c
| Intermediate
- 14 Videos | 1h 14m 2s
- Includes Assessment
- Earns a Badge
Discover how to get started with Oracle Database 12c, configure initialization parameters, start up a database instance, work with log files, and use the various database views.
WHAT YOU WILL LEARN
-
describe the Oracle Database 12c database management tools, SQL*Plus and SQL Developeraccess Enterprise Manager (EM) Database Express and provide an overview of the options it provides for managing Oracle Database 12cstart Oracle Enterprise Manager Cloud Control and describe its core components in Oracle Database 12cuse Enterprise Manager Cloud Control in Oracle Database 12cidentify types of initialization parameters and the files that contain them in Oracle Database 12cconfigure key initialization parameters in Oracle Database 12cdescribe how to use SQL*Plus to view and configure initialization parameters for Oracle Database 12c
-
explain the steps that occur when you start up a database instance in Oracle Database 12cexplain what occurs when you shut down a database instance, as well as the available shutdown modes, in Oracle Database 12cview the alert log and find and use trace files in Oracle Database 12cadminister the DDL log file and use the debug log file in Oracle Database 12cdescribe and use dynamic performance views in Oracle Database 12cdescribe and use the data dictionary views in Oracle Database 12cconfigure initialization parameters, start a database instance, and use different views in Oracle Database 12c
IN THIS COURSE
-
1.SQL*Plus and SQL Developer6m 27s
-
2.Introduction to Enterprise Manager Database Express5m 42s
-
3.Using Oracle Enterprise Manager Cloud Control4m 39s
-
4.Working with Oracle Enterprise Manager Cloud Control3m 57s
-
5.Overview of Initialization Parameters6m 58s
-
6.Configuring Key Initialization Parameters7m 15s
-
7.Using SQL*Plus to View and Configure Parameters5m 48s
-
8.Starting a Database Instance5m 14s
-
9.Shutting Down a Database Instance5m
-
10.The Alert Log and Trace Files5m 21s
-
11.DDL and Debug Log Files3m 27s
-
12.Dynamic Performance Views4m 41s
-
13.Data Dictionary Views4m 36s
-
14.Exercise: Configure, Start, and View a Database4m 56s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.