Course Outline

Introduction

  • Overview of Oracle database server architecture
  • Overview of Oracle multitenant container database
  • Oracle database instance and database sharding

Accessing Oracle Database

  • Connecting to an Oracle database instance
  • Using Oracle database tools
  • SQL*Plus
  • Using Oracle SQL developer
  • Using Database Configuration Assistant (DBCA)
  • Understanding the Enterprise Manager cloud control 13c features
  • Overview of Oracle Enterprise Manager component
  • Single pane of glass for enterprise management
  • Managing Oracle Enterprise Manager database

Creating an Oracle Database

  • Creating an Oracle database using DBCA
  • Creating an Oracle database using an SQL command

Working with Database Instances

  • Starting the Oracle database instance
  • Shutting down an Oracle database instance
  • Comparing Shutdown modes
  • Opening and closing PDBs
  • Configuring PDBs

Managing Database Instances

  • Using initialization parameters
  • Working with the automatic diagnostic repository
  • Viewing the alert log
  • Using trace files
  • Administering the DDL log file
  • Working with dynamic performance views
  • Using a data dictionary

Overview of Oracle Net Services

  • Defining components of Oracle net services
  • Configuring and managing Oracle net services
  • Overview of Oracle net listener
  • Comparing dedicated and shared server architecture

Naming Methods

  • Establishing Oracle network connections
  • Understanding the naming methods
  • Easy connect
  • Local and directory naming
  • Managing workloads using database services
  • Creating database services

Working with the Listener

  • Using the default listener
  • Configuring dynamic service registration
  • Configuring static service registration

Configuring a Shared Server Architecture

  • Enabling a shared server
  • Controlling shared server operations
  • Using SGA and PGA
  • Shared server configuration considerations

Configuring Oracle Connect Manager

  • Understanding Oracle Connection Manager
  • Using filtering rules
  • Implementing intranet and internet access control
  • Using session multiplexing
  • Configuring Oracle Connection Manager
  • Configuring the cman.ora file
  • Configuring clients
  • Configuring the database server
  • Using the Oracle Connection Manager control utility

Creating PDBs

  • Provisioning new pluggable databases
  • Creating a new PDB from PDB$SEED
  • Using the FILE_NAME_CONVERT clause
  • Using OMF or the PDB_FILE_NAME_CONVERT parameter
  • Other techniques for creating PDBs

Managing PDBs

  • Changing the PDB mode
  • Modifying PDB settings
  • Changing initialization parameters
  • Using the Alter System Command in a PDB
  • Configuring hostname and port number per PDB
  • Dropping PDBs

Understanding Database Storage

  • Database storage architecture
  • Database structures
  • Using segments, extents, and blocks
  • Using tablespaces and data files
  • Understanding the types of segments
  • Storing table data
  • Database block content
  • Managing deferred segment creation
  • Monitoring tablespace space usage

Managing Tablespaces

  • Creating tablespaces
  • Defining default permanent tablespaces
  • Working with temporary tablespaces
  • Altering and dropping tablespaces
  • Implementing Oracle Managed File (OMF)
  • Moving or renaming online data file

Improving Usage Space

  • Understanding space management features
  • Managing block space
  • Specifying table compression

Managing Undo Data

  • Managing transactions and undo data
  • Storing undo information
  • Configuring undo retention
  • Enabling temporary undo

Creating and Managing User Accounts

  • Oracle-supplied administrator accounts
  • Authenticating users
  • Assigning quotas

Configuring Privilege and Role Authorization

  • Understanding system privileges
  • Configuring system privileges
  • Managing privileges

Configuring User Resource Limits

  • Managing profiles and users
  • Understanding profile parameters

Oracle Database Auditing

  • Understanding database security
  • Auditing implementation
  • FGA policy

Loading and Transporting Data

  • Moving data
  • Data loading methods
  • Exporting and importing data
  • Transporting a database

Database Monitoring

  • Performance management activities
  • Maintaining databases
  • Understanding methods of performance tuning

Database Processes

  • Process architecture and structure
  • Using the different writer and monitor process

Managing Memory

  • Managing memory components
  • Automatic memory management

Analyzing SQL

  • Using Oracle optimizer
  • Optimising access paths
  • SQL plan directives

Summary and Next Steps

Requirements

  • Basic knowledge of SQL

Audience

  • System administrator
  • Technical consultant
  • Database administrator
  35 Hours
 

Number of participants


Starts

Ends


Dates are subject to availability and take place between 09:30 and 16:30.

Price per participant
Open Training Courses require 5+ participants.

Testimonials (2)

Related Courses

Related Categories