: Network Disk Download
Content EssentialsThis book is written for Oracle 11g, the latest large database management system from Oracle, and the basics of Oracle are presented in a circular, progressive way. Its content includes four parts: Basic concepts of Oracle, management of non-schema objects, management of schema objects, database security and recovery, etc. This book emphasizes combining theory with practice, and introduces the important content of database theory and the realization of Oracle 11g. Catalog Editor 1th Chapter Understanding Oracle
1.1 Basic Concepts in Oracle
1.1.1 Database
1.1.2 Instances
1.1.3 User and Mode
1.2 Oracle Installation
1.2.1 Oracle's application structure
1.2.2 Installation Environment
1.2.3 Management System Services
1.3 Oracle Tools
1.3.1 Using Sql*plus
1.3.2 using ouacle Enterprise Manager
1.4 Creating a Database
2nd Oracle's Basic architecture
2.1 Physical storage structure
2.1.1 Data files
2.1.2 Control files
2.1.3 Redo log Files
2.1.4 Other files
2.2 Logical storage structure
2.2.1 Table Space (Tablespade)
2.2.2 Segment (segment)
2.2.3 District (extent)
2.2.4 Blocks (block)
2.3 Oracle Instance Structure
2.3.1 Process Structure
2.3.2 Oracle Memory Architecture
2.4 Data dictionary
3rd Chapter Storage Management
3.1 Managing basic Table Spaces
3.1.1 Table Space Management types
3.1.2 Creating a basic table space
3.1.3 Modifying table spaces
3.2 Interim Table Middle
3.2.1 Creating a temporary table space
3.2.2 Modifying temporary table spaces
3.2.3 Temporary table space groups
3.3 Large File Table spaces
3.4 Non-standard chunk table space
3.5 Undo Table Space
3.5.1 Manage undo Table space
3.5.2 Creating and managing undo Table spaces
4th Chapter Management control files and log files
4.1 Administrative control Files
Overview of 4.1.1 Control files
Management strategy for 4.1.2 control files
4.1.3 using multi-journey multiplexing control files
4.1.4 Creating a control file
Backup and recovery of 4.1.5 control files
4.1.6 Deleting a control file
4.1.7 Query Control file information
4.1.8 OEM Management redo log files
4.2 Managing log files
4.2.1 Log files
4.2.2 Management policy for log files
4.2.3 Creating a Redo log group and its members
4.2.4 redefining and renaming log members
4.2.5 deleting redo log groups and their members
4.2.6 Manually switch logs
4.2.7 emptying the Redo log file
4.2.8 viewing redo log file information
4.2.9 OEM Management redo log files
4.3 Managing the collation log
4.3.1 The concept of archived logs
4.3.2 Setting the database schema
4.3.3 Setting archive targets
4.3.4 Setting the trace level of the archive process
4.3.5 Viewing archived log information
4.4 Parsing Redo log files
4.4.1 Logminer Overview
4.4.2 Extracting dictionary files used by Logminer
5th. SQL Statement Basics
6th. PL/SQL procedure
7th chapter Stored procedures, triggers, and packages
8th Chapter Table
9th Other Model objects
10th Chapter User and security
11th. Database Audit
12th. User management Backup and recovery
13th Chapter Recovery Manager
The 14th chapter data loading and transmitting
15th Oracle Flash Back
: Network Disk Download
Oracle 11g from getting started to mastering PDFs
