79671

79671



About Memory Management

Memory managcmcnt involves maintaining optimal sizes for thc Oracle instancc memory structures as dcmands on the databasc change. The memory that must be managed is thc System Global Area (SGA) memory and the instancc Program Global Area (PGA) memory. The instancc PGA memory is thc collection of memory allocations for all individual PGAs.

Beginning with Oracle Databasc 11# Release 1 (11.1), you can let thc databasc manage

the SGA memory and instancc PGA memory completely. You designate only the total memory sizc to be used by the instancc, and Oracle Databasc dynamically exchanges memory between the SGA and the instancc PGA as needed to meet processing dcmands. This capability is referred to as automatic memory managcmcnt. In this memory management modę, the databasc also dynamically tunes the sizes of the individual SGA components and the instancc PGA.



Wyszukiwarka

Podobne podstrony:
Managing Memory This section provides background information about managing memory for the Oracle in
About Administration Privileges for Startup and Shutdown To start or shut down thc Oracle instancc,
About Instance Startup Whcn you start thc Oracle instance, you typically start it such that the Stat
About Background Processes The background processes of the Oracle instancc manage memory structures,
About Software Management and Patch Releases Software management involves kccping your Oracle Databa
screenshot 2 Language Management (gTranslate Configuration) aryJ the SuPOOOJF-fltum- For help on how
About Initialization Parameters Managing an Oracle instance includes configuring parameters that aff
About Table Types The most common typc of table in an Oracle databasc is a relational table. which i
Dropping a Table For thc purpose of lcarning about Flashback Drop, you will crcatc a ncw table named
Overview of the Oracle Instance and Instance Management An Oracle database system consisLs of an Ora
Włodzimierz Bielecki, Krzysztof Kraska The assurance of the optimal performance for a program with t
Managing Mounted Drives Using mounted drives can help you manage and organize data on your server. F
image008 Conversion to Flash General Interface Advanced Memory Management Manage Flash player intern
NOKIA Subsystems and network elements in GSM Mobility management This maintains information about th
CPU ] Caches i Mainboard
ZARZĄDZANIE PAMIĘCIĄ MMU(Memory Management Unit):translacja adresów fizycznych na logiczne poprzez
About Instance Memory Structures The sizes of the instance memory structures affect database perform
About the Memory Advisors Adcquatc physical mcmory has a significant impact on thc performance of yo
Enabling Automatic Memory Management If you did not cnablc automatic me mory management whcn you ins

więcej podobnych podstron