用17张思维导图,学习Oracle 19C官网文档!
Oracle Database 19C
一.Install and Upgrade二.Administration三.Development四.Security五.Performance六.High Availability七.Data Warehousing八.Spatial and Graph九.Distributed Data十.Machine Learning十一.JSON, XML, Full-Text
Administration
一.Most Popular1.Database Administrator's Guide2.Database Concepts3.Database Error Messages4.Database Performance Tuning Guide5.Database Reference6.Multitenant Administrator's Guide7.Oracle Database Utilities Guide8.SQL Tuning Guide二.Backup and Recovery1.Database Backup and Recovery Reference2.Database Backup and Recovery User's Guide三.Clients for Database Administration1.SQL*Plus Quick Reference2.SQL*Plus Release Notes3.SQL*Plus User's Guide and Reference四.Network Management1.Database Net Services Administrator's Guide2.Database Net Services Reference五.Patching1.Oracle Database Patch Maintenance六.SQL and PL/SQL1.Database Development Guide2.Database PL/SQL Language Reference3.Database PL/SQL Packages and Types Reference4.SQL Language Quick Reference5.SQL Language Reference七.Storage1.Automatic Storage Management Administrator's Guide八.Testing1.Oracle Database Testing Guide九.UNIX and Windows Database Administration1.Administrator's Reference for Linux and Unix-Based Operating Systems2.Administrator's Reference Guide for Microsoft Windows
Database Concepts
一:Oracle Relational Data Structures1.Tables and Table Clusters2.Indexes and Index-Organized Tables3.Partitions, Views, and Other Schema Objects4.Data Integrity5.Data Dictionary and Dynamic Performance Views二: Oracle Data Access1.SQL2.Server-Side Programming: PL/SQL and Java三: Oracle Transaction Management1.Data Concurrency and Consistency2.Transactions四:Oracle Database Storage Structures1.Physical Storage Structures2.Logical Storage Structures五: Oracle Instance Architecture1.Oracle Database Instance2.Memory Architecture3.Process Architecture4.Application and Oracle Net Services Architecture六: Oracle Database Administration and Application Development1.Topics for Database Administrators and Developers2.Concepts for Database Administrators3.Concepts for Database Developers
Database Administrator's Guide
一: Basic Database Administration1.Getting Started with Database Administration2.Creating and Configuring an Oracle Database3.Starting Up and Shutting Down4.Configuring Automatic Restart of an Oracle Database5.Managing Processes6.Managing Memory7.Managing Users and Securing the Database8.Monitoring the Database9.Diagnosing and Resolving Problems二:Oracle Database Structure and Storage1.Managing Control Files2.Managing the Redo Log3.Managing Archived Redo Log Files4.Managing Tablespaces5.Managing Data Files and Temp Files6.Transporting Data7.Managing Undo8.Using Oracle Managed Files三:Schema Objects1.Managing Schema Objects2.Managing Space for Schema Objects3.Managing Tables4.Managing Indexes5.Managing Clusters6.Managing Hash Clusters7.Managing Views, Sequences, and Synonyms8.Repairing Corrupted Data四.Database Resource Management and Task Scheduling1.Managing Automated Database Maintenance Tasks2.Managing Resources with Oracle Database Resource Manager3.Oracle Scheduler Concepts4.Scheduling Jobs with Oracle Scheduler5.Administering Oracle Scheduler五:Distributed Database Management1.Distributed Database Concepts2.Managing a Distributed Database3.Developing Applications for a Distributed Database System4.Distributed Transactions Concepts5.Managing Distributed Transactions六:Managing Read-Only Materialized Views1.Read-Only Materialized View Concepts2.Read-Only Materialized View Architecture3.Planning for Read-Only Materialized Views4.Creating and Managing Read-Only Materialized Views5.Troubleshooting Problems with Read-Only Materialized Views
Database Performance Tuning Guide
一:Database Performance Fundamentals1.Performance Tuning Overview2.Designing and Developing for Performance3.Performance Improvement Methods4.Configuring a Database for Performance二:Diagnosing and Tuning Database Performance1.Measuring Database Performance2.Gathering Database Statistics3.Automatic Performance Diagnostics4.Comparing Database Performance Over Time5.Analyzing Sampled Data6.Instance Tuning Using Performance Views三:Tuning Database Memory1.Database Memory Allocation2.Tuning the System Global Area3.Tuning the Database Buffer Cache4.Tuning the Shared Pool and the Large Pool5.Tuning the Result Cache6.Tuning the Program Global Area四:Managing System Resources1.I/O Configuration and Design2.Managing Operating System Resources
Database Reference
一.Initialization Parameters1.Initialization Parameters二.Static Data Dictionary Views1.Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES2.Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES3.Static Data Dictionary Views: DBA_2PC_NEIGHBORS to DBA_HIST_JAVA_POOL_ADVICE4.Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGS5.Static Data Dictionary Views: DBA_STREAMS_ADD_COLUMN to USER_ZONEMAPS三:Dynamic Performance Views1.Dynamic Performance (V$) Views: V$ACCESS to V$HVMASTER_INFO2.Dynamic Performance (V$) Views: V$IM_COLUMN_LEVEL to V$RULE_SET_AGGREGATE_STATS3.Dynamic Performance (V$) Views: V$SCHEDULER_RUNNING_JOBS to V$ZONEMAP_USAGE_STATS四.Appendixes1.Database Limits2.SQL Scripts3.Oracle Wait Events4.Oracle Enqueue Names5.Statistics Descriptions6.Background Processes
Multitenant Administrator's Guide
一.Multitenant Architecture1.Introduction to the Multitenant Architecture2.Overview of the Multitenant Architecture二.Creating and Configuring a Multitenant Environment1.Overview of Configuring and Managing a Multitenant Environment2.Creating and Configuring a CDB三:Creating and Removing PDBs and Application Containers1.Overview of PDB Creation2.Creating a PDB from Scratch3.Cloning a PDB or Non-CDB4.Relocating a PDB5.Plugging In an Unplugged PDB6.Creating a PDB as a Proxy PDB7.Removing a PDB8.Creating and Removing Application Containers and Seeds四:Administering a Multitenant Environment1.Administering a CDB2.Administering PDBs3.Administering a PDB Snapshot Carousel4.Administering Application Containers5.Managing Security for a Multitenant Environment五.Using Oracle Features in a Multitenant Environment1.Backing Up and Recovering CDBs and PDBs2.Using Database Utilities in a Multitenant Environment3.Using Oracle Resource Manager for PDBs4.Using Oracle Scheduler with a CDB5.Using Oracle Database Vault with a CDB6.Using XStream with a CDB
Oracle Database Utilities Guide
一.Oracle Data Pump1.Overview of Oracle Data Pump2.Oracle Data Pump Export3.Oracle Data Pump Import4.Oracle Data Pump Legacy Mode5.Oracle Data Pump Performance6.Using the Oracle Data Pump API二.SQL*Loader1.Understanding How to Use SQL*Loader2.SQL*Loader Command-Line Reference3.SQL*Loader Control File Reference4.SQL*Loader Field List Reference5.Loading Objects, LOBs, and Collections with SQL*Loader6.Conventional and Direct Path Loads7.SQL*Loader Express三.External Tables1.External Tables Concepts2.The ORACLE_LOADER Access Driver3.The ORACLE_DATAPUMP Access Driver4.ORACLE_BIGDATA Access Driver5.External Tables Examples
SQL Tuning Guide
一.SQL Performance Fundamentals1.Introduction to SQL Tuning2.SQL Performance Methodology二.Query Optimizer Fundamentals1.SQL Processing2.Query Optimizer Concepts3.Query Transformations三:Query Execution Plans1.Explaining and Displaying Execution Plans2.PLAN_TABLE Reference四.SQL Operators: Access Paths and Joins1.Optimizer Access Paths2.Joins五.Optimizer Statistics1.Optimizer Statistics Concepts2.Histograms3.Configuring Options for Optimizer Statistics Gathering4.Gathering Optimizer Statistics5.Managing Extended Statistics6.Controlling the Use of Optimizer Statistics7.Managing Historical Optimizer Statistics8.Importing and Exporting Optimizer Statistics9.Analyzing Statistics Using Optimizer Statistics Advisor六.Optimizer Controls1.Influencing the Optimizer2.Improving Real-World Performance Through Cursor Sharing七.Monitoring and Tracing SQL1.Monitoring Database Operations2.Gathering Diagnostic Data with SQL Test Case Builder3.Performing Application Tracing八.Automatic SQL Tuning1.Managing SQL Tuning Sets2.Analyzing SQL with SQL Tuning Advisor3.Optimizing Access Paths with SQL Access Advisor九.SQL Management Objects1.Managing SQL Profiles2.Overview of SQL Plan Management3.Managing SQL Plan Baselines4.Migrating Stored Outlines to SQL Plan Baselines
Backup and Recovery Reference
一.Database Backup and Recovery Reference1.About RMAN Commands2.RMAN Commands: @ (at sign) to QUIT3.RMAN Commands: RECOVER to VALIDATE4.RMAN Subclauses5.Recovery Catalog Views二.Database Backup and Recovery User's Guide1.Overview of Backup and Recovery2.Starting and Configuring RMAN and Flashback Database3.Backing Up and Archiving Data4.Managing RMAN Backups5.Diagnosing and Responding to Failures6.Tuning and Troubleshooting7.Transferring Data with RMAN8.Setting Up RMAN for Cloud Backup and Restores9.Performing User-Managed Backup and Recovery
Clients for Database Administration
一.SQL*Plus Quick Reference二.SQL*Plus Release Notes三.SQL*Plus User's Guide and Reference1.SQL*Plus Getting Started2.Using SQL*Plus3.SQL*Plus Reference4.SQL*Plus Appendixes
Network Management
一.Database Net Services Administrator's Guide1.Understanding Oracle Net Services2.Configuration and Administration of Oracle Net Services3.Testing and Troubleshooting Oracle Net Services二.Database Net Services Reference1.Listener Control Utility2.Oracle Connection Manager Control Utility3.Syntax Rules for Configuration Files4.Protocol Address Configuration5.Parameters for the sqlnet.ora File6.Local Naming Parameters in the tnsnames.ora File7.Oracle Net Listener Parameters in the listener.ora File8.Oracle Connection Manager Parameters9.Directory Usage Parameters in the ldap.ora File
Patching
一.Oracle Database Patch Maintenance1.Introduction to Oracle Database Patch Maintenance2.Proactive Maintenance with RUs and MRPs3.Reactive Maintenance with One-off Patches4.Which Patching Method to Use?5.Patch Conflict Resolution6.Frequently Asked Questions7.Current Database Proactive Patches8.Documentation Accessibility
SQL and PL/SQL
一.Database Development Guide1.Database Development Fundamentals2.SQL for Application Developers3.PL/SQL for Application Developers4.Advanced Topics for Application Developers二.Database PL/SQL Language Reference1.Overview of PL/SQL2.PL/SQL Language Fundamentals3.PL/SQL Data Types4.PL/SQL Control Statements5.PL/SQL Collections and Records6.PL/SQL Static SQL7.PL/SQL Dynamic SQL8.PL/SQL Subprograms9.PL/SQL Triggers10.PL/SQL Packages11.PL/SQL Error Handling12.PL/SQL Optimization and Tuning13.PL/SQL Language Elements14.SQL Statements for Stored PL/SQL Units三.Database PL/SQL Packages and Types Reference1.Introduction to Oracle Supplied PL/SQL Packages & Types2.Oracle Application Express Packages APEX_APPLICATION Through APEX_ZIP3. …四.SQL Language Quick Reference1.SQL Statements2.SQL Functions3.SQL Expressions4.SQL Conditions5.Subclauses6.Data Types7.Format Models五.SQL Language Reference1.Introduction to Oracle SQL2.Basic Elements of Oracle SQL3.Pseudocolumns4.Operators5.Expressions6.Conditions7.Functions8.Common SQL DDL Clauses9.SQL Queries and Subqueries10.SQL Statements: ADMINISTER KEY MANAGEMENT to ALTER JAVA11. ...
Storage
一.Automatic Storage Management Administrator's Guide1.Introduction2.Oracle ASM Instances and Disk Groups3.Oracle Automatic Storage Management Cluster File System4.Advanced Topics
Testing
一.Oracle Database Testing Guide1.SQL Performance Analyzer2.Database Replay3.Workload Analysis
UNIX and Windows Database Administration
一.Administrator's Reference for Linux and Unix-Based Operating Systems1.Administering Oracle Database2.Stopping and Starting Oracle Software3.Configuring Oracle Database4.Administering SQL*Plus5.Configuring Oracle Net Services6.Using Oracle Precompilers and the Oracle Call Interface7.SQL*Loader and PL/SQL Demonstrations二.Administrator's Reference Guide for Microsoft Windows1.Oracle Database Architecture on Windows2.Database Tools on Windows3.Supporting Oracle Home User on Windows4.Postinstallation Database Creation on Windows5.Postinstallation Configuration Tasks on Windows6.Administering a Database on Windows7.Monitoring a Database on Windows8.Tuning Windows to Optimize Oracle Database9.Performing Database Backup and Recovery with VSS10.Authenticating Database Users with Windows11.Administering External Users and Roles on Windows12.Storing Oracle Wallets in the Windows Registry13.Oracle PKI Integration with Windows14.Using Oracle Database with Microsoft Active Directory15.Oracle Database Specifications for Windows16.Configuration Parameters and the Registry17.Developing Applications for Windows
参考:
https://docs.oracle.com/en/database/oracle/oracle-database/19/index.html想进一步了解AWR与等待事件相关姿势,与小伙伴们一起进步,请来下方这里: