les10 man mem10 tell me





Managing Memory












The interactions in this eCourse require Javascript to be enabled.



 

Managing Memory


previous|next





Each running Oracle database is associated with an Oracle instance. When a database is started on a database server, the Oracle software allocates a shared memory area called the System Global Area (SGA) and starts several Oracle background processes. This combination of the SGA and the Oracle processes is called an Oracle instance. After starting an instance, the Oracle software associates the instance with a specific database. This is called mounting the database. The database is then ready to be opened, which makes it accessible to authorized users. Multiple instances can execute concurrently on the same computer, each accessing its own physical database.
An Oracle database uses memory structures and processes to manage and access the database.


The basic memory structures associated with an Oracle instance include:

System Global Area (SGA): Shared by all server and background processes
Program Global Area (PGA): Private to each server and background proces, with one PGA for each process

The Oracle database uses initialization parameters to create and configure memory structures. The Oracle Database XE automatic memory management capabilities automatically adjust the memory distribution among the various SGA and PGA subcomponents for optimal performance. These adjustments are made within the boundaries of your total SGA and PGA target values.







Wyszukiwarka

Podobne podstrony:
les10 man mem20 tell me
les10 man tblspc10 tell me
les10 man mem10 show me
les10 man usr10 tell me
les10 man usr21 tell me
les10 man usr20 tell me
les10 man set20 tell me
les10 man tblspc20 tell me
les10 man set10 tell me
les10 man tblspc10 show me
les10 man usr10 show me
les10 man tblspc20 show me
les10 man set10 show me
les10 man usr20 show me
les10 mon?20 tell me
les10 mon?10 tell me
les05 ins tab20 tell me
Geri Halliwell Don t?ll me?by

więcej podobnych podstron