在写技术文档时，经常想到Oracle官方文档的某张经典图片，但查找时又比较耗时，索性将 Oracle 19C Database Concepts 所有经典图片保存下来，方便学习 ... 看过等于学会，点赞等于精通 ...
Figure 1-1 Oracle Instance and Database
Figure 1-6 Oracle Sharding Architecture
Figure 2-2 Segments, Tablespaces, and Data Files
Figure 2-5 Clustered Table Data
Figure 2-6 Retrieving Data from a Hash Cluster
Figure 2-7 Retrieving Data from a Hash Cluster When a Hash Collision Occurs
Figure 2-8 External Tables
Figure 3-1 Internal Structure of a B-tree Index
Figure 3-2 Bitmap Join Index
Figure 3-3 Index-Organized Table
Figure 3-4 Bitmap Index on Index-Organized Table
Figure 4-1 Composite Range-List Partitioning
Figure 4-2 Index Partitioning Options
Figure 4-3 Local Index Partitions
Figure 4-4 Global Partitioned Index
Figure 4-5 Partial Global Partitioned Index
Figure 4-6 Horizontal Partitioning of a Table Across Shards
Figure 4-8 Materialized View
Figure 5-1 Referential Integrity Constraints
Figure 5-2 Single Table Referential Constraints
Figure 8-2 Optimizer Components
Figure 8-3 Stages of SQL Processing
Figure 9-1 Multiple Executions of a Stored Procedure
Figure 9-3 The PL/SQL Engine and Oracle Database
Figure 9-4 Two-Tier Client/Server Configuration
Figure 9-5 Java Component Structure
Figure 10-1 Read Consistency in the Read Committed Isolation Level
Figure 10-2 Row and Table Locks
Figure 10-3 Locking Mechanisms with Unindexed Foreign Key
Figure 10-4 Locking Mechanisms with Indexed Foreign Key
Figure 11-1 A Banking Transaction
Figure 11-3 Check of Logical Transaction Status
Figure 12-1 Database Instance and Database Files
Figure 12-2 Oracle ASM Components
Figure 12-3 Oracle ASM Instance and Database Instances
Figure 12-4 Data Files and Tablespaces
Figure 12-5 Space in a Data File
Figure 12-6 Reuse of Online Redo Log Files
Figure 12-7 Multiple Copies of Online Redo Log Files
Figure 13-1 Logical and Physical Storage
Figure 13-2 Segments, Extents, and Data Blocks Within a Tablespace
Figure 13-3 Logical Space Management
Figure 13-4 Bitmap-Managed Storage
Figure 13-5 Free List Groups
Figure 13-6 Data Blocks and Operating System Blocks
Figure 13-7 Data Block Format
Figure 13-8 The Format of a Row Piece
Figure 13-11 Data Block with Fragmented Space
Figure 13-12 Data Block After Coalescing Free Space
Figure 13-13 Row Chaining
Figure 13-14 Row Migration
Figure 13-15 Index Before Coalescing
Figure 13-16 Index After Coalescing
Figure 13-17 Initial Extent of a Segment
Figure 13-18 Incremental Extent of a Segment
Figure 13-20 Multiple Segments
Figure 13-21 Ring of Allocated Extents in an Undo Segment
Figure 13-22 Cyclical Use of Allocated Extents in an Undo Segment
Figure 13-23 Allocation of a New Extent for an Undo Segment
Figure 13-24 HWM at Table Creation
Figure 13-25 HWM and Low HWM
Figure 13-26 HWM and Low HWM
Figure 13-27 Advancing HWM and Low HWM
How Shadow Tablespaces Work
Figure 14-1 Database Instance
Figure 14-2 Database Instance Configurations
Figure 14-3 Instance and Database Startup Sequence
Figure 14-4 Instance and Database Shutdown Sequence
Figure 14-5 Checkpoint Position in Online Redo Log
Figure 14-6 Basic Instance Recovery Steps: Rolling Forward and Rolling Back
Figure 14-7 Multiple Initialization Parameter Files
Figure 14-8 ADR Directory Structure for an Oracle Database Instance
Figure 15-1 Oracle Database Memory Structures
Figure 15-2 User Global Area (UGA)
Figure 15-6 Buffer Search
Figure 15-7 Database Buffer Cache
Figure 15-8 Redo Log Buffer
Figure 15-10 Private SQL Areas and Shared SQL Area
Figure 15-12
Deferred Insert
Mechanism
Figure 15-13
Memoptimize Pool
Figure 16-1 Oracle Processes and the SGA
Figure 16-2 One Session for Each Connection
Figure 16-3 Two Sessions in One Connection
Figure 16-4 Checkpoint Process
Figure 16-5 Serial Full Table Scan
Figure 16-6 Producers and Consumers
Figure 16-7 Parallel Full Table Scan
Figure 17-1 Client/Server Architecture and Distributed Processing
Figure 17-2 Client/Server Architecture and Distributed Database
Figure 17-3 A Multitier Architecture Environment
Figure 17-4 Two Listeners
Figure 17-5 Listener Architecture
Figure 17-6 Multiple Services Associated with One Database
Figure 17-7 Oracle Database Using Dedicated Server Processes
Figure 17-8 The Shared Server Configuration and Processes
Figure 18-1 Common Uses for Roles
Figure 18-2 Grid Computing Environment
Figure 18-3 Architecture of a Data Warehouse
Data Warehouse Architecture (with a Staging Area)
Figure 18-5 Architecture of a Data Warehouse with a Staging Area and Data Marts
Figure 18-6 Database Link
Figure 18-7 Oracle Message Queuing
Figure 19-1 SQL*Loader Session
Figure 19-2 Oracle Data Pump Architecture
Figure 19-3 RMAN Architecture
Figure 19-4 Recovery Appliance Environment
Figure 19-5 Memory Management Methods
Figure 19-6 Automatic Memory Management
Figure 19-7 Simple Resource Plan
Figure 19-8 Scheduler Components
Figure 19-9 Automatic Workload Repository (AWR)
Figure 20-1 Application Express with Embedded PL/SQL Gateway
Figure 20-2 Program Development with Precompilers
Figure 20-3 Development Process Using OCI or OCCI
Figure 20-4 Catalog Query Application
https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/index.html
欢迎关注我的公众号《IT小Chen》
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29785807/viewspace-3095700/
，如需转载，请注明出处，否则将追究法律责任。
' fill='%23FFFFFF'%3E%3Crect x='249' y='126' width='1' height='1'%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E)
