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