Oracle 12c Database DBA Entry Guide Directory

Source: Internet
Author: User
Tags arithmetic operators dba rollback sessions

Dangdang page Link:

Http://product.dangdang.com/23625712.html

The 1th chapter Oracle Database Basic knowledge
1.1 What is a relational database
1.1.1 Relational Database model
Founder of 1.1.2 Relational data model
1.2 Oracle Database Development history
The beginning of 1.2.1 Company
1.2.2 Oracle Database development process
1.3 Database RDBMS
1.4 SQL Language Introduction
1.4.1 SQL Language Overview
1.4.2 SQL statements
1.5 Summary of this chapter
2nd Chapter Oracle 12c Database initial Experience
2.1 Environment requirements for installing databases
2.2 Oracle 12c installation steps in a Windows environment
2.3 Sqlplus Tools and Scott users
2.4 Summary of this chapter
Chapter 3rd the start and shutdown of the database
3.1 Starting the database
3.1.1 Database startup process
3.1.2 Database boot to Nomount state
3.1.3 Database boot to mount state
3.1.4 Database boot to open state
3.2 Closing the database
3.2.1 The database shutdown process
Several parameters of 3.2.2 database shutdown and its implication
3.3 Quiesce and Suspend database
3.4 Summary of this chapter
4th Chapter Oracle Database Architecture
4.1 Oracle Architecture Overview
4.2 Oracle Database Architecture
4.2.1 Oracle Servers and instances
4.2.2 The physical structure of Oracle databases (file composition)
4.2.3 Oracle database parameter files and password files
4.3 Database connections (connection) sessions (session)
4.3.1 database connection (connection)
4.3.2 Sessions (session)
4.4 The memory structure of Oracle databases
4.4.1 Shared Pool
4.4.2 Database Cache buffer Area (db buffer cache)
4.4.3 Redo log High speed buffer area (redo buffer cache)
4.4.4 Large pool (large pool) and Java pool
4.4.5 Stream (Streaming pool)
4.4.6 PGA (Process global area) and UGA (User global area)
4.4.7 How to obtain information on memory buffers
4.5 Oracle Server processes and user processes
4.6 Oracle Database background process
4.6.1 System Monitoring Process (Smon)
4.6.2 Process monitoring process (Pmon)
4.6.3 Database Write process (DBWR)
4.6.4 Redo Log Write process (LGWR)
4.6.5 Archive Log process (ARCH)
4.6.6 checkpoint processes (checkpoint process)
4.7 Summary of this chapter
5th Chapter SQL Language Overview
Classification of 5.1 SQL statements
5.2 SQL query statement
Syntax and writing requirements of 5.2.1 SELECT statements
5.2.2 Simple Query
5.2.3 a specific column query
5.2.4 WHERE clause
5.2.5 the default display format for column headings
5.2.6 the alias of a column in an SQL statement
5.2.7 arithmetic operators and their use
5.2.8 distinct operator
5.2.9 Connection (contatenation) operator and use
5.3 Writing Specifications
5.4 Single-line functions
5.4.1-Character Single-line function
5.4.2 Numeric single-line function
5.4.3 Date-type single-line function
5.5 null (NULL) and null-value processing functions
5.5.1 What is a null value
5.5.2 NVL functions and NVL2 functions
5.5.3 Nullif function
5.5.4 COALESCE function
5.6-Piece Expression
5.6.1 CASE Expression
5.6.2 decode function
5.7 Grouping functions
5.7.1 avg and SUM functions
5.7.2 Max and Min functions
5.7.3 Count function
5.7.4 GROUP BY clause
Nested use of 5.7.5 grouping functions
5.7.6 HAVING clause
5.8 Data Manipulation Language (DML)
5.8.1 INSERT statement
5.8.2 UPDATE statement
5.8.3 DELETE statement
5.9 Summary of this chapter
6th Chapter Data Dictionary
6.1 The contents of the data dictionary
6.2 Using and manipulating data dictionary views
6.3 Data Dictionary View classification
6.4 Using the Data dictionary view
6.5 Dynamic performance View and usage
6.6 Summary of this chapter
7th Chapter Network Configuration Management
7.1 Oracle's network connection
7.2 Server-side listener configuration
7.2.1 Dynamic Registration
7.2.2 Static Registration
7.2.3 Connection Test
7.2.4 Monitoring Program Management
7.3 Client Configuration
7.3.1 Local naming
7.3.2 Simple naming
7.4 Two connection modes supported by Oracle database server
7.4.1 Server process
7.4.2 Shared connections
7.4.3 shared connection involves initialization parameters
7.4.4 A shared connection's work process
7.4.5 the configuration of shared connections
Some problems with 7.4.6 shared connections
7.4.7 Proprietary Connection
7.5 Database Resident Connection Pool
The working principle of 7.5.1 DRCP
7.5.2 How to configure DRCP
7.6 Summary of this chapter
8th Chapter Memory Management
8.1 Memory Architecture
8.1.1 PGA Overview
8.1.2 SGA Overview
8.1.3 UGA Overview
8.2 Memory Management
8.2.1 Configuring Memory Components
Automatic adjustment of 8.2.2 SGA and PGA
8.2.3 limits the size of the PGA
8.2.4 Configuration Database Intelligent Cache
8.3 Summary of this chapter
Chapter 9th User Management and resource files
9.1 Creating users
9.1.1 the creation of new users
9.1.2 Create user syntax and parameter implications
9.1.3 Changing user parameters
9.2 Delete User
9.3 User and database schemas
9.4 Important files in user management-profile
9.4.1 What is a profile
9.4.2 Resource management and password management profile usage steps
9.4.3 use profiles to manage session resources
9.4.4 Password management parameters and implications
9.4.5 Create a password-managed profile
9.5 Modifying and deleting a profile
9.6 Summary of this chapter
10th Chapter Control File and Database startup
10.1 Overview of control file and database startup
10.2 How to obtain the information of the control file
10.3 Contents of the control file
10.3.1 the content stored in the control file
10.3.2 How to view the record information of the contents stored in the control file
10.4 Storing multiple control files
10.4.1 Multiple control files
10.4.2 Mobile Control File
10.4.3 Add control File
10.5 Backup and Recovery control files
10.5.1 Control File Backup
10.5.2 Control File Recovery
10.6 Summary of this chapter
11th Chapter Redo Log Management
11.1 Why Oracle introduced redo logs
11.2 Read Redo log file information
11.2.1 V$log View
11.2.2 V$logfile View
11.2.3 judge whether to file
11.2.4 Set Database as archive mode
11.3 Redo log groups and their management
11.3.1 Add Redo Log Group
11.3.2 Delete online redo log Group
11.4 Redo Log Members and maintenance
11.4.1 Add Redo Log Members
11.4.2 Delete online Redo log members
11.4.3 Reset the online redo log size
11.5 Clear Online Redo logs
11.6 Log switching and checkpoint events
11.7 Archive Redo Log
11.8 Summary of this chapter
12th Chapter Management Archive Log
12.1 Archive Mode
12.2 Setting the archive mode
12.3 Setting up the archive process and archive directory
12.4 Maintain the archive directory
12.5 Summary of this chapter
13th chapter table space and data file management
Logical Structure of 13.1 Oracle database
13.2 Table space Classification and creation of table spaces
13.3 table space Two scenarios for disk Management
Table space Disk Management for 13.3.1 data dictionary management
13.3.2 locally managed table Space Disk Management
13.4 Creating a table space
13.4.1 Create a table space for data dictionary management
13.4.2 Create a locally managed table space
13.4.3 Create a Restore table space
13.4.4 Create temporary table spaces
13.4.5 Default Temp Table space
13.4.6 Create a large file table space
13.5 Table Space Management
13.5.1 Offline Management
13.5.2 read-only management
13.6 table space and data file management
13.6.1 Modify Table Space size
13.6.2 Modify the storage parameters of the table space
13.6.3 Delete Table Space
13.6.4 Migrate data files
13.6.5 data dictionaries and locally managed table spaces
13.7 Summary of this chapter
14th Chapter Undo Table Space Management
14.1 The effect of introducing the reduction section
14.2 How the restore segment completes read consistency
14.2.1 How Oracle realizes read consistency
Further complication analysis of 14.2.2 reading consistency
Specific steps for 14.2.3 read consistency
14.3 instance recovery and transaction rollback of a restore segment
Selection algorithm of 14.4 UNDO segment
14.5 discussion of undo_retention parameters
14.6 Reduction Segment Classification
14.7 Oracle's automatic restore segment management
14.8 Create a Restore table space
14.9 Maintenance Restore Table space
14.10 Toggle Restore Table Space
14.10.1 Undo Table Space Switch Example
State of 14.10.2 Unod table space Switching
14.10.3 Remove the Undo Table space Sample
14.11 Temporary Undo
14.12 dba_undo_extents Data Dictionary
14.13 Summary of this chapter
Chapter 15th Affairs (Transaction)
The origin of 15.1 Oracle affairs
15.2 What is a business
15.3 Characteristics of the transaction
15.4 Transaction Control
15.4.1 explicit transaction control using commit
15.4.2 uses rollback to implement transaction control
The effect of 15.4.3 program exception exit on transaction
15.4.4 use Autocommit to implement automatic transaction submission
15.5 Summary of this chapter
16th Chapter Role Management
16.1 What is a role
16.2 Creating roles
16.3 Modifying roles
16.4 Assigning permissions to roles
16.5 Giving user roles
16.6 Default Roles
16.7 prohibition and activation of roles
16.8 Reclaim and delete roles
16.9 Oracle-Predefined roles
16.10 Summary of this chapter
17th chapter Management and Maintenance table
17.1 Oracle Basic data storage mechanism--table
Storage type for 17.1.1 data
17.1.2 row ID (ROWID)
17.2 Creating a Table
17.2.1 Oracle Create a table rule
17.2.2 Create a normal table
17.2.3 Create a temporary table
17.3 Invisible Fields
17.4 Segment Space Management
17.5 Understanding high Watermark Line (HWM)
17.6 Understanding Row Migration
17.7 creating an Index organization table (IOT)
Structure of 17.7.1 IoT table
17.7.2 Create IoT table
17.8 table parameters and parameter maintenance
17.9 Maintenance Columns
17.10 Deleting and truncating tables
17.11 Table Compression
17.12 top-n Query
17.13 Summary of this chapter
18th Chapter Index
18.1 concept of the Index
18.2 Oracle Implementation of data access method
18.2.1 full table scan (scan,fts)
18.2.2 via row ID (ROWID)
18.2.3 Using Indexes
18.3 Index Scan Type
18.3.1 index unique Scan (index unique SCAN)
18.3.2 Index Range Scan (index range SCAN)
18.3.3 Index Full SCAN
18.3.4 index Fast Scan (index fast full SCAN)
18.4 Limiting the use of indexes
18.4.1 use not equal to operator
18.4.2 use is null or is not NULL
18.4.3 using Functions
18.4.4 Compare mismatched data types
18.5 set Group Factor
18.6 two Yuan height
18.7 histogram
18.8 Index Creation
18.9 Viewing indexes
18.10 B-Tree Index
The working principle of 18.10.1 B-Tree Index
Considerations for 18.10.2 B-Tree indexing
18.11-bit Graph index
18.11. Use discussion of 1-bit graph index
18.11.2 Create a bitmap index
18.11. Insert problem for 3-bit graph index
18.12 Hash Index
18.13 Reverse Key index
18.14 Function-based indexing
18.15 the use of the monitoring index
18.16 Reconstruction Index
18.17 Maintenance Index
18.18 Delete Index
18.19 Summary of this chapter
19th Chapter System and object Rights management
19.1 Concepts and classifications of permissions
19.2 System permissions
19.3 Granting User System privileges
19.4 SYSDBA and Sysoper system privileges
19.5 Reclaim User System permissions
19.6 Granting Object permissions
19.7 Reclaim Object permissions
19.8 Summary of this chapter

Chapter 20th View
20.1 What is a view
20.2 Creating a View
20.3 using the WITH clause of the view
20.4 changes to the view
20.5 Oracle's view Management
20.5.1 query views through a data dictionary
Internal procedures for 20.5.2 Oracle view queries
20.6 View limitations of DML operations
20.6.1 Simple View
20.6.2 Complex View
20.7 Advantages of view
20.8 Delete View
20.9 materialized views
20.9.1 What is materialized view
The concept of 20.9.2 query rewriting
Synchronization of 20.9.3 materialized views
20.9.4 Create materialized views
20.9.5 the use environment of materialized views
20.10 Summary of this chapter
21st chapter serial numbers and synonyms
21.1 What is serial number
21.2 creating and using serial numbers
21.3 Modify serial Number
21.4 Session serial Number
21.5 Delete Serial Number
21.6 what is a synonym
21.7 creating public synonyms
21.8 creating private synonyms
21.9 removing synonyms
21.10 Switching user mode
21.11 Summary of this chapter
Chapter 22nd Rman Backup and Recovery database
22.1 Rman Overview
The uniqueness of 22.2 Rman
22.3 Rman System Architecture detailed
22.4 Fast flash recovery zone (Flash recovery area)
22.4.1 Modify the Flash recovery area size
22.4.2 solve the problem of space shortage in flash recovery area
22.5 establishing the connection of Rman to the database
Related concepts and configuration parameters of 22.6 Rman
22.7 Rman Backup control file
22.8 Rman to implement offline backup
22.9 Rman Online Backup
22.9.1 Preparation before online backup
22.9.2 Online Backup of the entire database
22.9.3 Online backup of a table space
22.9.4 Online Backup of a data file
22.9.5 Rman Backup bad block processing method
Incremental backup of 22.10 Rman
22.11 Fast Incremental backups
22.12 applying an incremental backup on the image copy
22.13 Creating and maintaining the recovery directory
Script Management for 22.14 Rman
22.15 Full recovery using Rman in non-archive mode
22.15.1 control files, data files, and redo log file loss recovery
22.15.2 only recovery of data file loss
22.15.3 online redo log files and data file corruption recovery
22.15.4 How to restore a data file to a different disk directory
22.16 Full recovery using Rman archive mode
22.16.1 recovery of non-system table space corruption
Recovery of 22.16.2 system table space Damage
22.16.3 recovery of all data file loss
22.17 Rman realizes data block recovery
22.18 Rman Backup Maintenance instructions
Validate backupset instructions for 22.18.1 Rman
22.18.2 Rman Restore ... Validate directives
22.18.3 Rman Restore ... Preview directives
22.18.4 Rman's List command
22.18.5 Rman's command
22.19 Summary of this chapter
23rd Chapter Oracle Flash back Technology
23.1 Understanding the Flash back level
23.2 Flash back to database
23.2.1 Flash-Back Database overview
23.2.2 Enable flash back database
23.2.3 Shutdown Flash Back database
23.2.4 Flash-Back database method
23.2.5 use flash back database
23.2.6 monitoring flash back to database
23.2.7 use of Flash-back database restrictions
23.3 Flash-back deletion
23.3.1 Flash-back deletion principle
Use of 23.3.2 Recycle Bin
23.3.3 Recovery of deleted tables
23.3.4 recover multiple tables with the same name
23.3.5 Apply purge permanently delete table
23.4 Flash return table
23.5 Flash back version query
23.6 Flash-Back transaction query
23.7 Flash back Query
23.8 Recovery Point Technology
23.9 Summary of this chapter
24th Chapter Manual Management of Backup recovery
24.1 Concept of Backup recovery
24.1.1 Physical Backup
24.1.2 Logical Backup
24.1.3 cold backup and hot backup
24.1.4 Database Recovery
24.2 Lengbei and recovery in non-archival mode
Steps for 24.2.1 Lengbei
Recovery of 24.2.2 Cold Benie
24.2.3 Missing Redo log File recovery method
24.3 Archive mode and non-archive mode
24.3.1 set up the archive mode of the database
24.3.2 set up archive process related parameters
24.3.3 Management archive and archive directory
24.4 Steps for manual hot standby database
The processing method of database crash in 24.5 hot standby process
24.6 Principle of hot standby
24.7 Backup Control files
24.8 Principle of media recovery
24.9 Full recovery in archive mode
24.9.1 data File Recovery in case of backup
24.9.2 recovery of data files without backup
24.9.3 system table space data file corruption Full recovery
24.9.4 Full recovery of current undo table space corruption
24.9.5 Full recovery of non-current undo table space corruption
24.10 When to use incomplete recovery
24.10.1 not fully recovered from the occasion
24.10.2 type of incomplete recovery
24.11 recovery methods for all control file loss
24.11.1 Use Backup control files
24.11.2 Reconstruction Control File
24.12 Summary of this chapter

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.