Oracle storage architecture in-depth analysis and management _ Beyond OCP proficient Oracle Video Tutorial Training 07

Course Objectives

Oracle Video tutorial, wind Brother this set of Oracle Tutorials Training Learning bbed, data blocks, including in-depth analysis of Oracle data storage architecture, tablespaces (tablespace), segments (segments), zones (Extent), database blocks (db Block), table, index, System and sysaux and temp table space for daily management and maintenance.

Applicable people

It-related practitioners, Oracle database technicians, those who want to pay, want to get promoted.

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/8B/26/wKiom1hFdyDRJDKEAADYldUcQ4g304.jpg-wh_500x0-wm_3 -wmp_4-s_2201177921.jpg "title=" Oracle Tutorial "alt=" Wkiom1hfdydrjdkeaadylducq4g304.jpg-wh_50 "/>

Course Address:

Http://edu.51cto.com/course/course_id-3899.html

Course Introduction

This course introduces:

Oracle Video tutorial, wind Brother this set of Oracle Tutorials Training Learning bbed, data blocks, including in-depth analysis of Oracle data storage architecture, tablespaces (tablespace), segments (segments), zones (Extent), database blocks (db Block), table, index, System and sysaux and temp table space for daily management and maintenance. Details are as follows:

Familiar with the storage structure of database and the relationship between table space and data file

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?

The introduction of database block and how Orcale 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 concept/type/creation/usage rules

Analysis of ROWID field type and structure

The function and application of temporary table

Row migration and linking of tables

Indexing function and classification

Index creation and indexing routine maintenance operations

Table space creation/daily maintenance Management/performance and security

Table space and data security issues and cases

DDL/DML/DCL Understanding and table space creation related parameter description

Table space Performance vs. non-standard block size tablespace creation

Table space Migration process (data files vs. objects)

Table space Maintenance and status checks

Oracle-managed files (OMF)

What if the system and the Sysaux table space are full?

How do I handle a temporary tablespace when it is full?

Default temp table space too large to handle

This article is from the Oracle Database tutorials Blog, so be sure to keep this source http://oracle13c.blog.51cto.com/8020378/1879759

Oracle storage architecture in-depth analysis and management _ Beyond OCP proficient Oracle Video Tutorial Training 07