. Specify data_buffer. (This parameter is not required after sga_max_size is specified in Oracle9i)
Alter system set db_cache_size = 80000000 scope = spfile;
C. large_pool_size
D. java_pool_size
2. PGA
In 9i, this Part has also changed a lot.
In standalone mode, 9i no longer claims to use the original UGA-related parameter settings, instead of new parameters.If workarea_size_policy = auto (default), The UGA of all sessions share a large blo
address3) transaction operation code4) updated data
Each time you modify these blocks in cache buffer, you must first generate the corresponding change vector in PGA, and then copy the data from server process to SGA redo log buffer. The user process generates a redo entries when modifying data. In this case, the redo logs are stored in the PGA, And the redo copy latch is required to copy the redo logs in
Document directory
SGA (system global areas)
PGA (Program global areas)
Background Process
Instances and databases
Oracle Server = oralce instance + Oracle Databse
DBMS (data base management system) database management system, as its name implies, is a data management system. Data must first be available and then managed through instances, an instance is a memory structure and background process. In short, it is a running program, and processes a
Original article:
Http://qa.taobao.com /? P = 7887
Since Oracle introduced the automatic management of memory parameters for 10 Gb, it seems that the problem of sga pga parameter settings that had plagued DBAs has been gradually ignored. Yes. Theoretically, we only need to allocate about 80% of the system's memory to the dB, and leave the remaining memory to the OS and other applications. This is a very good practice principle and is also recogniz
contain data and control information of an Oracle DB instance. SGA is shared by all servers and background processes. Examples of data stored in SGA include cache data blocks and shared SQL regions.
Program global Zone(PGA): memory area that contains data and control information of a server process or background process. PGA is the non-shared memory created by Oracle DB when the server process or backgroun
In versions earlier than Oracle9i, you can only control the UNIX memory used by Oracle when starting the database. Oracle provides some INIT. ORA parameters to check the RAM size of the system global area, SGA. Once the database is started, you cannot change the size and configuration of the SGA.
Oracle's goal of moving towards a database of 24/7 is to adjust the size of the UNIX memory zone without having to stop or restart the database. More importantly, the dynamic SGA feature of Oracle9i all
ManagementSimply set the Sga_target parameter, which is assigned by Oracle according to the actual situationManual management (set Log_buffer lower value)Sql> alter system set LOG_BUFFER=73400320 Scope=spfile;=====================================How to set the SGA and PGA based on experience valuesSGA set this size of 70%-80%PGA sets this size of 20%-30%Sql> Select T.sga_size,t.estd_physical_reads from V$s
Managing Memory in Administrator's Guide, managingdire
Automatic Memory Management
1. If you want to enable Automatic Memory Management, how can you determine the value of MEMORY_TARGET?
1> show parameter target under SQL * Plus. The result is as follows:
SQL> show parameter targetNAME TYPE VALUE------------------------------------ ----------- ------------------------------archive_lag_target integer 0db_flashback_retention_target
(SGA) is allocated and background processes are started.The database includes the physical structure and logical structure. Because the physical structure and logical structure are separated, the access to the logical storage structure is not affected when you manage the physical storage of data.
Oracle architecture ensures that the logical structure is abstracted from the physical structure
Oracle DB Memory StructureOracle DB creates and uses memory structures for various purposes. For example
4 SYS391460F4 5 SYS
Now let's check in which Oracle memory region this memory address resides (SGA, PGA, UGA etc ). i'm using my scriptfcha for this (Find CHunk Address ). you shoshould probably not run this script in busy production systems as it uses the potentially dangerous X $ KSMSP fixed table:
SQL> @fcha 391513C4Find in which heap (UGA, PGA or Shared Pool) the memory address 391513
) Query/workspacememory:In Oracle-like Pga,mssql, query Memoy (also known as workspace memory) is used to store temporary results during query execution when hashing and sorting. Although we all know that Oracle's PGA, but MSSQL's query memory may not be too many documents to read, so there is not too many people are clear and know, including MSSQL background process,memory components and other internal det
ProcessOracle Memory ArchitectureIncludes system global Area (SGA) and program Global (PGA)Oracle Memory structures = SGA + PGAThe SGA is shared by the server and background processesThe PGA contains data and control information for a single server process or a single background process, contrary to the SGA shared by several processes, the PGA isZones that are u
Oracle knowledge point summary (1) architecture: the database architecture refers to the composition, working process and principles of the database, and the organization and management mechanism of data in the database. The architecture includes: instance, database, user process, server process ), and other files (such as parameter files, password files, and archive log files ). The Oracle server consists of database files and database instances. Database instances include SGA (a set of memory
Oracle Database learning-basic structure popularize basic knowledge of oracle. To sum up, oracle is composed of instances and databases. The structure is as follows: www.2cto.com the oracle database consists of instances and databases: * The database consists of data files (including oracle Data, indexes, table structures, and other data) and control files (including the operation information of each table) log Files (SQL statements for data operations), parameter files, password files, and log
The following articles mainly introduce the Oracle memory structure research-SGA. I saw the introduction of PGA in Oracle memory structure research-PGA two days ago. PGA is a dedicated private memory zone for a server process, while SGA is a shared memory zone.
As mentioned in the Oracle Memory Structure Study-PGA,
-availability SQL statements use unoptimized execution plans.IV. The process cannot be found.
Solution ()
I. Fix the Bug. The most effective way to get all these fixes is to apply the latest PSU patch ). Document 756671.1 provides detailed information about the latest PSU.II. Implement hugepages. For more information, see Document 361670.1-Slow Performance with High CPU Usage on 64-bit Linux with Large SGA.III. Optimize the SQL statements that cause excessive buffer gets and high cpu consumption
When the client connects to the oracle database through the network in the form of "connect user name/password @ connection string", the listener needs assistance. After the connection is established, even if the listener fails, the established connection will not be affected.
There are two main ways for users to connect to the oracle database server: private server connection and shared server connection.
In dedicated server mode, each user process running a database application is provided
associated with one database, but one database may be accessed by multiple instances.
When a database file is read to the memory, it is an Instance. An Instance divides the occupied memory into multiple blocks. The database we operate on is the Instance in the memory, the database cannot be operated directly. When we obtain a Connection through JDBC to connect to this Instance, the Instance will open up a memory (PGA) for this Connection, and there w
Analysis of OCP questions 053-16 MEMORY_TARGET, ocp053-16
16. Setting which of the following initialization parameters enables Automatic Memory Management?A. MEMORYJARGET
B. MEMORY_MAX_TARGET
C. SGATARGET
D. PGA AGGREGATE TARGET
Answer:
[Resolution]
The MEMORY_MAX_TARGET parameter is added to the 11g file. This parameter is as refreshing as the first SGA_MAX_SIZE parameter appears in 10g. Memory_max_target is used to set the maximum memory space occ
To sum up the basic knowledge of oracle, oracle is composed of instances and databases. The structure is as follows:
Oracle databases consist of instances and databases:
* A database consists of data files (including oracle Data, indexes, table structures, and other data), control files (including operation information for each table), and log files (SQL statements for data operation) parameter files, password files, and log archive files (in archive mode) (used for log recovery when the server
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.