Oracle 12c Database dba Getting Started directory

Source: Internet
Author: User
Tags arithmetic operators

Dangdang page Link:

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

1th. Oracle Database Basics
1.1 What is a relational database
1.1.1 Relational Database model
Founder of the 1.1.2 relational data model
1.2 A brief history of Oracle database development
The beginning of 1.2.1 Company
1.2.2 The evolution of Oracle Database
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 Oracle 12c Database First Experience
2.1 Environment requirements for installing databases
2.2 Installation steps for Oracle 12c in a Windows environment
2.3 Sqlplus Tools and Scott users
2.4 Summary of this chapter
3rd. Start and close of 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 Database shutdown process
Several parameters of 3.2.2 database shutdown and their meanings
3.3 Quiesce and Suspend database
3.4 Summary of this chapter
Chapter 4th 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 the Oracle database (file composition)
4.2.3 Oracle database parameter files and password files
4.3 Database connection (connection) session (session)
4.3.1 database connection (connection)
4.3.2 Sessions (session)
4.4 The memory structure of the Oracle database
4.4.1 Shared Pool
4.4.2 Database Buffer Cache
4.4.3 Redo Log Cache zone (redo buffer cache)
4.4.4 Large pool (large pool) and Java pools
4.4.5 Stream Pond (streaming pool)
4.4.6 PGA (Process Global Zone) and UGA (User global Zone)
4.4.7 How to obtain the memory buffer information
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 Progress (checkpoint process)
4.7 Summary of this chapter
5th. SQL Language Overview
5.1 Classification of SQL statements
Query statements for 5.2 sql
Syntax and writing requirements for the 5.2.1 SELECT statement
5.2.2 Simple Query
5.2.3 a specific column query
5.2.4 WHERE clause
5.2.5 default display format for column headings
5.2.6 using 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 Connect (contatenation) operator and use
5.3 Writing Specifications
5.4 Single-line function
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 value (NULL) and NULL handler function
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-BAR 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 Content in 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 working process for shared connections
7.4.5 Configuration of shared connections
7.4.6 some issues with shared connections
7.4.7 Proprietary Connection
7.5 Database Resident Connection Pool
How the 7.5.1 DRCP works
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 Configuring the Database Smart Cache
8.3 Summary of this chapter
9th Chapter User Management and resource files
9.1 Creating a user
9.1.1 New User's creation
9.1.2 Creating user syntax and parameter meanings
9.1.3 Changing user parameters
9.2 Deleting a user
9.3 User and Database mode
9.4 Important files in user management--profiles
9.4.1 What is a profile
9.4.2 use of resource management and password management profiles
9.4.3 managing session Resources with profiles
9.4.4 Password management parameters and implications
9.4.5 creating password-managed profiles
9.5 Modifying and deleting profiles
9.6 Summary of this chapter
10th. control File and Database startup
10.1 Overview of control file and database startup
10.2 How to get information about a control file
10.3 Controlling the contents of a file
10.3.1 what is stored in the control file
10.3.2 How to view record information for content stored in a control file
10.4 Storing multiple control files
10.4.1 Multiple control files
10.4.2 Mobile Control files
10.4.3 Adding control files
10.5 Backup and Recovery control files
10.5.1 Backup of control files
10.5.2 Control File Recovery
10.6 Summary of this chapter
The 11th Chapter Redo log Management
11.1 Why Oracle introduces redo logs
11.2 Read Redo log file information
11.2.1 V$log View
11.2.2 V$logfile View
11.2.3 decide whether to archive
11.2.4 Setting the database to archive mode
11.3 Redo log groups and their administration
11.3.1 adding redo Log groups
11.3.2 Deleting an online redo log group
11.4 Redo Log Members and maintenance
11.4.1 adding redo Log Members
11.4.2 Delete online Redo log members
11.4.3 resetting the size of the online redo log
11.5 Clearing the online redo log
11.6 Log switchover and checkpoint events
11.7 Archive Redo Logs
11.8 Summary of this chapter
12th. Managing Archive Logs
12.1 Archive Mode
12.2 Setting the archive mode
12.3 Set archive process and archive directory
12.4 Maintaining the archive directory
12.5 Summary of this chapter
13th chapter table space and data file management
13.1 Logical Structure of Oracle Database
13.2 Classification of table spaces and creation of table spaces
13.3 table Space Disk Management two scenarios
13.3.1 table Space Disk Management for data dictionary management
13.3.2 locally managed table Space Disk Management
13.4 Creating a table space
13.4.1 Creating a table space for data dictionary management
13.4.2 Creating a locally managed table space
13.4.3 Creating a Restore table space
13.4.4 Creating a temporary table space
13.4.5 Default temporary table space
13.4.6 creating large File Table spaces
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 modifying the storage parameters of a table space
13.6.3 Deleting a table space
13.6.4 Migrating data files
13.6.5 data dictionaries and locally managed tablespaces
13.7 Summary of this chapter
14th Chapter Undo Table Space Management
14.1 Introduction of the effect of the reduction segment
14.2 How restore segments complete Read consistency
14.2.1 How Oracle achieves read consistency
Further complication analysis of 14.2.2 read consistency
14.2.3 to read the consistency of the specific steps
14.3 instance recovery and transaction rollback for a restore segment
Selection algorithm of 14.4 UNDO segment
14.5 discussion undo_retention Parameters
14.6 Reduction Segment Classification
14.7 Automatic restore segment management for Oracle
14.8 Creating a Restore table space
14.9 Maintaining the Restore table space
14.10 Switching the Restore table space
14.10.1 Undo Table Space Switch Example
14.10.2 Unod table space Switching involved states
14.10.3 Removing the Undo tablespace example
14.11 Temporary Undo
14.12 dba_undo_extents Data Dictionary
14.13 Summary of this chapter
Chapter 15th Affairs (Transaction)
15.1 The origin of Oracle transactions
15.2 What is a transaction
15.3 Characteristics of the business
15.4 Transaction Control
15.4.1 explicit transaction control using commit
15.4.2 using rollback for transaction control
Effect of abnormal exit of 15.4.3 program on transaction
15.4.4 using AUTOCOMMIT to automate transaction submission
15.5 Summary of this chapter
Chapter 16th Role Management
16.1 What is a role
16.2 Creating a role
16.3 Modifying roles
16.4 Assigning role Permissions
16.5 Assigning a user role
16.6 Default Roles
16.7 Disable and activate roles
16.8 Recovering and deleting roles
16.9 Oracle pre-defined roles
16.10 Summary of this chapter
17th chapter Management and Maintenance table
17.1 Oracle's basic data storage mechanism-table
17.1.1 Storage type of data
17.1.2 Line ID (ROWID)
17.2 Creating a Table
17.2.1 rules for Oracle to create tables
17.2.2 Creating a normal table
17.2.3 Creating a temporary table
17.3 Invisible Fields
17.4-Segment Space management
17.5 Understanding high watermark (HWM)
17.6 Understanding Row Migrations
17.7 Create an index organization table (IOT)
17.7.1 the structure of an IoT table
17.7.2 Creating an IoT table
17.8 table parameters and parameter maintenance
17.9 Maintaining 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's approach to implementing data access
18.2.1 full table scan (scan,fts)
18.2.2 by Row ID (ROWID)
18.2.3 Using Indexes
18.3 Index Scan Type
18.3.1 index unique scanning (index unique scan)
18.3.2 Index Range Scan
18.3.3 Index Full Scan
18.3.4 index Fast Scan (index fast full scan)
18.4 Restricting the use of indexes
18.4.1 using the not equals operator
18.4.2 using is null or is not NULL
18.4.3 using Functions
18.4.4 comparing data types that do not match
18.5 cluster factor
18.6 two Yuan height
18.7 histogram
18.8 Building an Index
18.9 View Index
18.10 B-Tree Index
How the 18.10.1 B-Tree Index works
18.10.2 B-Tree Index considerations
18.11-bit Graph index
18.11. Discussion on the use of 1-bit graph indexes
18.11.2 Creating 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 indexes
18.15 monitoring the use of indexes
18.16 Rebuilding the Index
18.17 Maintaining Indexes
18.18 Deleting an index
18.19 Summary of this chapter
The 19th Chapter system and object Rights management
19.1 Concepts and classifications of permissions
19.2 System permissions
19.3 Granting User system permissions
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

20th Chapter View
20.1 What is a view
20.2 Creating a View
20.3 using the view's with clause
20.4 changes to the view
20.5 View Management for Oracle
20.5.1 querying views through a data dictionary
20.5.2 Internal procedures for Oracle view queries
20.6 View restrictions for DML operations
20.6.1 Simple View
20.6.2 Complex views
20.7 Advantages of the view
20.8 Deleting a view
20.9 materialized views
20.9.1 What is materialized view
20.9.2 The concept of query rewriting
20.9.3 materialized View synchronization
20.9.4 Creating materialized views
20.9.5 the use environment of materialized views
20.10 Summary of this chapter
21st chapter serial Number and synonyms
21.1 What is a serial number
21.2 creating and using serial numbers
21.3 Changing the serial number
21.4 Session serial Number
21.5 deleting serial numbers
21.6 what is a synonym
21.7 creating a public synonym
21.8 creating a private synonym
21.9 deleting synonyms
21.10 Switching user mode
21.11 Summary of this chapter
22nd. Rman Backup and Recovery database
22.1 Rman Overview
The unique features of 22.2 Rman
22.3 Rman System Architecture detailed
22.4 Flash Recovery Zone (recovery area)
22.4.1 Modifying the Flash recovery area size
22.4.2 solve the problem of space shortage in flash recovery area
22.5 establishing an Rman-to-database connection
Related concepts and configuration parameters of 22.6 Rman
22.7 Rman Backup control file
22.8 Rman for offline backup
22.9 Rman Online Backup
22.9.1 Pre-online backup preparation work
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 mode
Incremental backup of 22.10 Rman
22.11 Fast Incremental backup
22.12 applying an incremental backup on the image copy
22.13 Creating and maintaining a recovery catalog
22.14 Rman's script management
22.15 Full recovery with rman non-archive mode
22.15.1 control files, data files, and redo log file loss recovery
22.15.2 only data file loss recovery
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 with Rman archive mode
22.16.1 recovery of non-system tablespace corruption
22.16.2 system table Space Corruption recovery
22.16.3 recovery of all data files lost
22.17 Rman for Data block recovery
22.18 Rman Backup Maintenance instructions
22.18.1 Rman's validate backupset directive
22.18.2 Rman's Restore ... Validate directive
22.18.3 Rman's Restore ... Preview Instructions
22.18.4 Rman's list directive
22.18.5 Rman's report instructions
22.19 Summary of this chapter
23rd Oracle Flash Back Technology
23.1 Understanding Flashback Level
23.2 Flash back to the database
23.2.1 Flash Back Database overview
23.2.2 enabling the Flash back database
23.2.3 Close the Flashback database
23.2.4 Flash Back Database method
23.2.5 using Flash back database
23.2.6 Monitoring Flash back database
23.2.7 limitations of using the Flashback database
23.3 Flash Back Delete
23.3.1 Flash Back Removal principle
Use of the 23.3.2 Recycle Bin
23.3.3 Recovering a deleted table
23.3.4 recover multiple tables with the same name
23.3.5 Apply purge permanently delete a table
23.4 Flash Back 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 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 cold and recovery in non-archive mode
Steps to 24.2.1 Cold
Recovery of 24.2.2 Cold prepared
24.2.3 Missing Redo log File recovery method
24.3 Archive mode and non-archive mode
24.3.1 Setting the archive mode of the database
24.3.2 Setting the archive process parameters
24.3.3 Managing archive files and archive directories
24.4 steps to manually hot-standby a database
24.5 How to deal with database crashes during hot standby
24.6 Principle of hot preparation
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 the case of backup
24.9.2 data File Recovery in the absence of 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 restored to the occasion
24.10.2 types that are not fully recovered
24.11 recovery method for all control file loss
24.11.1 using a backup control file
24.11.2 Rebuilding control files
24.12 Summary of this chapter



Oracle 12c Database dba Getting Started directory

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.