01.ORACLE storage structure in-depth analysis and management of course content introduction

Course Overview:

1. Review of the course contents of the previous chapter

2. Introduction to the course content of this chapter

3. Learn the preface to this course

After you have completed the previous chapters, you should be able to master the following:

Oracle Network-related concepts and common configuration files

Familiar with monitoring management tools

Create and manage monitoring services

To test Oracle NET connectivity using tnsping

Monitoring static and dynamic registration

How to increase database service

Production environment How to configure a second monitoring optimized data transfer

Local=no and Local=yes in the Oracle server process

Oracle monitoring and Client Configuration Essentials analysis

Configuration files Listener.ora and Tnsnames.ora detailed

Oracle client Installation and PL/SQL connection service side

ADR tools and logs in Oracle 11G

Oracle monitoring log configuration and routine maintenance specifications

Modify the Listening log file name

Standard practice for monitoring log file backup and renaming

Oracle monitoring security and password management

Network connection using db_link between two databases

About shared servers and dedicated servers

Oracle-Monitored firewall features restrict client access to Oracle

Oracle monitoring and Client connection failure Check analysis process

How Oracle can drill down to network failures with trace tracking issues

After completing this section, you should be able to grasp the following content:

Familiarize yourself with the relationship between tablespaces and data files

Table space Definition and default tablespace introduction

Definition/Type of segment (segments)/Understanding the creation and allocation of segments

How is the district (Extent) introduced and how is the district allocated?

Database block and how Oracle manages data storage

The basic structure and data block of database block in-depth analysis

Bbed analyzing database block structure and modifying data blocks

Bbed processing failure of data block inconsistent ora error

Table concepts, types, creation, usage rules

Analysis of ROWID field type and structure

The function and application of temporary table

Row migration and linking of tables

Database block is the smallest storage unit of a database

01.ORACLE storage structure in-depth analysis and management of course content introduction