Oracle DBA必看的130张高清无码大图

小周的数据库进阶之路 2025-10-09

43

在写技术文档时，经常想到Oracle官方文档的某张经典图片，但查找时又比较耗时，索性将 Oracle 19C Database Concepts 所有经典图片保存下来，方便学习 ... 看过等于学会，点赞等于精通 ...

Figure 1-1 Oracle Instance and Database

Figure 1-6 Oracle Sharding Architecture

Figure 2-1 HR Schema

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-7 View

Figure 4-8 Materialized View

Figure 4-9 Query Rewrite

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 9-7 Triggers

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-9 ROWID Format

Figure 13-10 PCTFREE

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

Figure 13-28 Tablespaces

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-3 Instance PGA

Figure 15-4 PGA Contents

Figure 15-5 Cursor

Figure 15-6 Buffer Search

Figure 15-7 Database Buffer Cache

Figure 15-8 Redo Log Buffer

Figure 15-9 Shared Pool

Figure 15-10 Private SQL Areas and Shared SQL Area

Figure 15-11 Large Pool

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 17-9 DRCP

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》

文章转载自小周的数据库进阶之路，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

评论