Overview of the System Global Area (70)
A system global area (SGA) is a group of shared memory structures that contain data
and control information for one Oracle database instance. If multiple users are
concurrently connected to the same instance, then the data in the instance’s SGA is
shared among the users. Consequently, the SGA is sometimes called the shared global
area.
An SGA and Oracle processes constitute an Oracle instance. Oracle automatically
allocates memory for an SGA when you start an instance, and the operating system
reclaims the memory when you shut down the instance. Each instance has its own
SGA.
SGA
一組共享的包含資料和控制資訊的記憶體結構 , Oracle例項由sga和Oracle程式組成 。
當例項啟動時 ,Oracle自動分配記憶體 , 例項shutdown時 , 作業系統回收記憶體 。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-977439/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Code Area和Data Area有什麼區別
- Flutter OverviewFlutterView
- SAP WM PICKING AREA
- dart class overviewDartView
- [英] TensorFlow OverviewView
- Overview of Availability in a CDBViewAI
- SCSS !globalCSS
- The runtime data area model of JVMJVM
- 7-Overview-namesView
- 8-Overview-NamespacesViewnamespace
- 10-Overview-AnnotationsView
- 2.4 Overview of Services in a CDBView
- 高通USB overviewView
- DeepLearning – Overview of Sequence modelView
- Spring Cloud: Overview 概述SpringCloudView
- [LeetCode] 695. Max Area of IslandLeetCode
- 【easy】695. Max Area of Island
- SAP WM Picking Area的使用
- 4.4global
- JavaScript Global 物件JavaScript物件
- Deep Global Registration
- 9-Overview-Labels and SelectorsView
- 11-Overview-Field SelectorsView
- 12-Overview-Recommended LabelsView
- Overview-(概述 What is Kubernetes)View
- 4-Overview-Kubernetes APIViewAPI
- 2.6.2 Overview of Flashback PDB in a CDBView
- 2.2.7 Overview of PDB Lockdown ProfilesView
- 2.2.6 Overview of Common Audit ConfigurationsView
- An Overview of PostgreSQL & MySQL Cross ReplicationViewMySqlROS
- 【Machine Teaching】An Overview of Machine TeachingMacView
- 【Oracle】排序與sort_area_sizeOracle排序
- GLOBAL TEMPORARY TABLE(轉)
- Codeforces Global Round 26
- Codeforces Global Round 27
- Codeforces Global Round 13
- @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty
- 5-Overview-Understanding Kubernetes ObjectsViewObject
- 6-Overview-Kubernetes Object ManagementViewObject