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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Overview of the Program Global Areas (97)View
- GFS (RedHat Global File System) 介紹Redhat
- 12c 新特性之 Limiting the Size of the Program Global AreaMIT
- Protecting Your Database: Specifying Passwords for Users SYS and SYSTEM (70)Database
- Drilling fluids ZJ70 solids control systemUISolid
- Code Area和Data Area有什麼區別
- sort_area_retained_size與sort_area_sizeAI
- Flutter OverviewFlutterView
- Oracle 11gR2 fast recovery area = flash recovery areaOracleAST
- dart class overviewDartView
- Stormstarter-OverviewORMView
- Overview of PartitioningView
- Overview of Database CheckpointsViewDatabase
- Overview of Unix ResourcesView
- oracle function overviewOracleFunctionView
- Item Import OverviewImportView
- Overview of Extents(11)View
- Overview of Partitioned IndexesViewIndex
- Overview of Tablespaces (38)View
- Overview of Views (174)View
- Overview of Datafiles (62)View
- Overview of Segments (22)View
- 高通USB overviewView
- oracle Flash Revovery AreaOracle
- Oracle pending areaOracle
- SCSS !globalCSS
- Overview of Availability in a CDBViewAI
- 2.4 Overview of Services in a CDBView
- 7-Overview-namesView
- 8-Overview-NamespacesViewnamespace
- 10-Overview-AnnotationsView
- [英] TensorFlow OverviewView
- Deadlock Overview and DiscussionView
- Overview of Data Blocks(二)ViewBloC
- Overview of Clusters (238)View
- Overview of Tables (154)View
- Overview of Dimensions (191)View
- Overview of Synonyms (193)View