When a user process connects to the database and creates a corresponding session, the Oracle service process sets a PGA zone for the user to store the relevant content of the user session. When the user session ends, the Database System Automatically releases the memory occupied by the PAG zone. This PGA zone has a great impact on database performance, especially for sorting operations. Therefore, properly
one or more auto-sizing components. If the size of the manually resized component decreases, the freed memory is provided to the automatically resized component.Program Global Zone (PGA)The program Global Zone (PGA) is a memory area that contains data and control information for a server process. This is the non-shared memory that is created by the Oracle server when the server process starts, and is acces
As a complex Oracle database system, the SQL statements submitted by different users are processed every moment, obtaining the data and returning the data to the user. As already mentioned, parsing an SQL statement is done in a shared pool in an Oracle instance. So, for each session, where are the binding variables passed in when the SQL statement is executed? And for those sessions that need to perform more complex SQL, such as ordering (sort) or hash joins (Hash-join), where does the memory sp
1. Concept
PGA: The program global area, the memory area used by the server process, including data and control information for a particular server process, such as private information and operating system resources used.
UGA: The user global area, the memory area used by a specific session, such as the SQL workspace for the session, login authentication information, and so on. The impact of the session's SQL workspace size on query performance is c
Oracle servers are primarily made up of instances, databases, program global, foreground processesExample: used to provide the ability to administer a databaseDatabase: Consists of an Oracle database file that is used to store system data, typically: Data files, control files, redo log filesThe instance can be further divided into: System global Area (SGA) and background process (Pmon,smon, etc.)While the SGA is a memory resource for the operating system, the background process uses the CPU and
Modifying the Oracle Database SGA and PGA sizeSize of the SGA: general physical memory 20% is used as the operating system reservation, and the other 80% is for the database.The SGA Normal database can be allocated between 40%-60% and the PGA can be allocated between 20%-40%.1. Log in As Systemand view the SGA information:sql>show parameter SGA;To view the PGA in
Tags: Io ar file data C on R work ad
PGA: it fully serves server process. It is allocated when server process is created and released when server process is terminated. it is not shared and only serves this server process independently. (Private memory space of server process)Purpose:
1. stores the private data and control files required for server process SQL Execution2. Session space, storing session and other related information3. SQL Workspace:
In dedicated mode, the PGA stores stackspace, usersessiondata, and cursorstate. In shared mode, only stackspace is placed under PGA. While userser
In dedicated mode, the PGA stores stack space, user session data, and cursor state. In shared mode, only stack space is placed under PGA. User ser
In dedicated mode,
Tags: instruction class update variable content private Area LOB permissionsPga-program Global AreaThe PGA memory area is private and not shared, and any operations initiated by the user against the database, whether queries or updates, are preprocessed in the region before entering the instance area (which is done by the SGA and the system daemon process).What are the main pretreatment?First, save the user's connection information, such as session pr
局区 (PGA) memory
Show Parameter Pga_aggregate_target
Show parameter SGA;
#除了SGA_MAX_SIZE, all others are dynamic parameters, that is, parameters that can be modified dynamically during database operation using the ALTER SYSTEM statement
Show Parameter Sga_max_size
#sga颗粒查询
#所有的SAG (each pool) with a minimum of memory unit particles (granule, also called the District Group)
sql> Select Component,granule_size fromv$sga_dynamic_components;
This co
2011-05-10 14:57:53Category: LinuxFirst, the memory structureSGA (System Global area): Shared by all service processes and background processes;The PGA (Program Global Area): is proprietary to each service process, background process, and each process has a PGA.Second, SGAcontains the data and control information for the instance, including the following memory structure: 1) database buffer cache: Blocks of data retrieved from disk are cached.2) Redo
Basic information:
Database Version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
Operating system version: CentOS release 5.6
To speed up index creation, consider the following:
Use nologging Parameters
Use parallel Parameters
Use manual pga at the session level and manually adjust sort_area_size
Modify other parameters
Note: hash_area_size is not adjusted manually here. By default, hash_area_size is automatically
The following articles mainly describe the actual application of Process Memory in the Oracle storage structure. We all know the actual application processes of Oracle except for the SGA (System Global Area, the following three global zones are also frequently used:
The Process Global Area (PGA );
The User Global Area (UGA );
The Call Global Area (CGA ).
Many people do not know the difference between PGA
The following articles mainly introduce the Process Memory in the Oracle Memory structure. This article describes the Process Memory in the Oracle Memory structure. If you are an Oracle enthusiast. The following article will be meaningful to you.
Process Memory in Oracle Memory Structure
The Process Memory, in addition to The SGA (System Global Area), The Oracle Process also uses The following three Global zones:
The Process Global Area (PGA );
The
Oracle
The Process Memory:
In addition to the SGA (System Global area), the Oracle process also uses the following three global zones:
The Process Global area (PGA)
The User Global area (UGA)
The call Global area (CGA)
A lot of people don't know the difference between PGA and UGA, in fact, the difference between the two is similar to the difference between a process and a session. Although it is genera
Welcome to the Oracle community forum and interact with 2 million technical staff to enter the PGA (ProcessGlobalArea), a private memory zone of serverprocess, which contains global variables, data structures, and some control information. In Oracle8i, PGA adjustment is very complex. You need to adjust SORT_AREA_SIZE, HASH_AREA_SIZE, BITMAP_MERGE_A
Welcome to the Oracle Community Forum, interact with 2 mill
. The SGA database activity in each zone can be monitored independently, and resources can be allocated and retrieved according to the pattern used in the Oracle database.
Let's first look at some of the differences between the following Oracle9i database and the Oracle8i database. One of the most important oracle9i is that there is no need to have a separate PGA space for all the dedicated connections to the Oracle database. In Oracle8i, for a dedic
Basic information Situation:DB version: Oracle database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionOperating system version: CentOS release 5.6Speed up index creation the main consideration is from the point of view:
Using the nologging parameter
Using parallel parallel parameters
Use the manual PGA at the session level to manually adjust the Sort_area_size
Modify other parameters
Note : We do not manually adju
, similar to the built-in macro _ line _ in C Language __
$ FuncnameThe function name is similar to the built-in macro _ FUNC __in C language. However, macro _ FUNC _ can only represent the name of the current function, while $ funcname is more powerful, it is an array variable that contains the names of all functions in the call chain. Therefore, the variable $ {funcname [0]} represents the name of the function currently being executed by the shell script, the variable $ {funcname [1]} indicate
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.