The PGA (Program Global region area) is a memory area that contains data and control information for a service process. It is created by Oracle at the start of a service process and is unshared. An Oracle process has a PGA memory area. A PGA can only be accessed by the service process that owns it, and only the Oracle code in the process can read and write to it.
Oracle 9i PGA usage control
We know that Oracle has provided the automatic PGA management function since 9i. From then on, we can skip the annoying settings such as sort_area_size and hash_area_size, and do not need to compute the tedious PGA size. But how can we control the size of PGA used by each session? Will there
I. Glossary (1) SGA: System Global Area is a basic component of Oracle Instance, which is allocated when the Instance is started. The System fully-local SGA consists of three parts: the Shared Pool, data buffer, and log buffer.(2) Shared Pool: Shared Pool is used to cache recently executed SQL statements and recently used data definitions, including Library cache (Shared SQL zone) and Data dictionary cache (Data dictionary Buffer ). The shared SQL zone is the area where user SQL commands are sto
Oracle evaluates the execution plan with the PGA_AGGREGATE_TARGET parameter, and selects the maximum or minimum memory that can be used in sort, HASH_JOIN, or Bitmap operations.
Oracle evaluates the execution plan with the PGA_AGGREGATE_TARGET parameter, and selects the maximum or minimum memory that can be used in sort, HASH_JOIN, or Bitmap operations.
Pga_aggregate_target is usually abbreviated as P_A_T. This parameter also limits global pga al
Modify the size of the oracle database SGA and PGA to modify the size of the SGA and PGASGA: Generally, 20% of the physical memory is used for the operating system reservation, and 80% of the other is used for the database. The SGA common database can be allocated between 40%-60%, and the PGA can be allocated between 20%-40%. Www.2cto.com 1. Log On As A dba and view the SGA information: SQL> show parameter
Use of statistical memory from the PGA and UGA of Thomas Kyte, using different sizes of the sorting area to view the PGA, UGA, and physical reads of different memory usesSession 1: Create a test table and test different sort sizesCREATE TABLE T as SELECT * from All_objects;exec dbms_stats.gather_table_stats (user, 't');Create a test tableCreate Run_query script: To control the size of the memory parameter s
Pga
The PGA (Program Global region area) is a memory area that contains data and control information for a service process. It is created by Oracle at the start of a service process and is unshared. An Oracle process has a PGA memory area. A PGA can only be accessed by the service process that owns it, and only the Or
Pga
The PGA (Program Global region area) is a memory area that contains data and control information for a service process. It is created by Oracle at the start of a service process and is unshared. An Oracle process has a PGA memory area. A PGA can only be accessed by the service process that owns it, and only the Or
Understanding the PGAPGA (Program Grlobal areas or process global area) refers to the private memory space of the service process, including the service process global variables, data structure and control information, such as cursors for the service process SQL query, the PGA consists of the following structures:Private SQL Zone: The private data and control structures required by the storage service process to execute SQL, including the fixed area a
Prior to Oracle 9i, we managed the use of the PGA primarily by setting parameter values such as Sort_area_size, hash_area_size (usually called *_area_size), but, strictly speaking, managed the UGA in the PGA. However, there is a problem, that is, these parameters are for a session, that is, the set of parameter values for all log in to the database session is effective. In the actual operation of the databa
1. What is the difference between PGA and SGA?
SGA is the global area of the system, and PGA is the global area of the process.
Oracle is running, and SGA is the memory structure of oracle, such as putting databuf and share pool, allocating at oracle startup, and recycling at oracle shutdown.
When a PGA is used to connect an oracle database, oracle opens a mem
10gOracle provides a series of Automatic Optimization suggestions,PGAHow much power can be allocated to bring the greatest performance to the system? The V $ pga_target_advice view provides a good "prediction "!Let's take a look at what information this view can bring to us (each column in the view is helpful ):Sys @ ora10g> select pga_target_for_estimate/1024/1024 "PGA (MB )",2 pga_target_factor,3 estd_pga_cache_hit_percentage,4 estd_overalloc_count5
The result set of the select statement may be stored in the UGA area of pga. Q: Where is the returned result set stored when oracle performs the select Operation? Is the rowid set or real data saved in the result set? Is the returned result set in the PGA region? If real data is returned, Will memory overflow be caused if the data volume is too large? High Level
The result set of the select statement may be
Welcome to the Oracle community forum and interact with 2 million technical staff before entering Oracle9i. The calculation and control of PGA is complicated, starting from Oracle9i, oracle provides a new SQL Memory Management Method: Automatic SQL Execution memory management (AutomatedSQLExecutionMemoryManagement ).
Welcome to the Oracle community forum and interact with 2 million technical staff> before entering Oracle9i, the calculation and control
Suggestions on the size of the initial SGA database and the size of the PGA database, sgapga1. Background information
Many new business systems are launched, and most DBAs do not understand the business, so they are bored with the header database creation. The SGA value is set to a large value, and the PGA is set to a large value. After a period of operation, it may be because this value is randomly specifi
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. When usersProcessWhen you connect to the database and create a corresponding session, the Oracle service process sets a
follows:1. Allocate UGA space for sessions in the MTS (earlier versions of the Shared Server) mode.2. As a buffer for continuous file I/O, such as system-managed recovery and RMAN backup recovery (when RMAN uses multiple Io slaves)In general, the use of large pool is not required, so it is not necessary to set a large pool.
E. Java pool:The purpose of introducing the Java pool is to compile Java-language commands. To use the Java language, you must set the Java pool. The Oracle database stored
When a user process connects to a database and creates a corresponding session, the Oracle service process specifically sets up a PGA zone for that user to store relevant content for that user session. When this user session is terminated, the database system automatically frees the memory occupied by the Pag area. This PGA zone has a significant impact on the performance of the database, especially with re
1, view SPFile location
Show parameter SPFile;
2, Backup SPFile
Create pfile= '/oracle/pid/bak/spfileecp.ora ' from SPFile;
3, set up dynamic management parameters automatic management
Note Shared test settings (if memory 15G shared memory cannot be more than 8G)
alter system setpga_aggregate_target=0 Scope=spfile;
alter system setmemory_max_target=18g Scope=spfile;
alter system setmemory_target=18g Scope=spfile;
4. Close the database
Shutdown immediate;
5, open the database
Oracle recommends that the OLTP (on-line TransactionProcessing) system accounts for 80% of the total system memory, and then allocates 80% to SGA and 20% to PGA. That isSGA = system_total_memory * 80% * 80%PGA = system_total_memory * 80% * 20%1. Global zone of the SGA System
SGA refers to the System GlobalArea, which is the memory area used to store database information. This information is shared by databa
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.