Architecture Diagram Learning:
The story of Lao Yu's clothing store
Structure diagram:
SQL query Statements
Sga
Shared pool
Data buffer Buffer Cache
Pga
Process
SQL UPDATE statement
Sga:
Log buffers
Log file
Deep learning
Submit
Rolling back
Consistent
the transaction in the Redo log file;8), if the transaction succeeds, the server process sends the message to the application.3. Oracle ServerI, Oracle server consists of Oracle database and Oracle instance.II, an Oracle database is a collection of data stored in a data file that is treated as a logical unit.III. Oracle instances are composed of background processes and memory structures that manage the database.4. Oracle InstanceI, Oracle instance is a collection of memory structures and backg
the transaction in the Redo log file;8), if the transaction succeeds, the server process sends the message to the application.3. Oracle ServerI, Oracle server consists of Oracle database and Oracle instance.II, an Oracle database is a collection of data stored in a data file that is treated as a logical unit.III. Oracle instances are composed of background processes and memory structures that manage the database.4. Oracle InstanceI, Oracle instance is a collection of memory structures and backg
Oracle BASICS (9) Oracle architecture and oracle infrastructure
1. Oracle Architecture Overview:
Oracle architecture refers to the composition, working process and principle of the database, as well as the organization and management mechanism of data in the database. To understand the architecture of Oracle databases, you must understand important concepts and main components of the Oracle system.
The Oracle system architecture consists of three parts: memory structure, process structure, and s
1, UGA (the User Global area)
The PGA is a piece of memory that contains data and control information for an Oracle service or background process. The PGA size depends on the configuration of the system. In dedicated services (dedicated Server) mode, a service process is associated with a user process, and the PGA includes heap space and UGA. However, the UGA (u
Error | resolution
Analyze and resolve ora-4030 errors
What does ORA-4030 mean?
This error means that the Oracle server process cannot obtain more memory from the operating system. The memory here refers to the PGA (Program Global Area) and its subkeys that are determined by the configuration. For dedicated server processes, memory includes the stack area, UGA (User Global area). UGA includes user session data, cursor information, and sorting ar
Oracle
The Oracle database server consists primarily of two components: databases and instances.
Instance
. Instance Memory Structure: SGA (System global Areas) and PGA (program global Areas)
. Instance's process structure: service processes and background processes
Memory structure:
SGA (System global Areas)
1. Database Cache Db_cach_size
. Keep Cache Pool Buffer_pool_keep
. Recycle Cache Pool Buffer_pool_recycle
. Default Cache Pool db_cache_size-
Oracle optimization of database memory parametersØ Oracle -related system kernel parameters Ø SGA,PGA parameter setting Oracle lower disk storage performance OptimizationØ File System selection (ext2/ext3,xfs,ocfs2) Ø Oracle ASM storage 1. What to know before optimizing Oracle performance Parameters1) How large is the physical memory2) The operating system estimates how much memory to use3) Whether the database is using a file system or a bare de
Tags: CLI shared pool Global and Otto table structure show introductionBasic points of knowledgeBasic memory structure: Sga+pga+uga+software code area (software region)Learn about the components of SGA memory and some common featuresLearn about Oracle 11G automatic memory management capabilitiesSpecific introductionAn Oracle DB instance is composed of some columns of the system global zone and the background process.The way a client accesses a databas
Sharing the SQL area, private SQL area, and game Benchmark 1. Sharing the SQL area is another way to name the handle of the cursor object in Librarycace and the data of the Child heap. Ii. Concept of private SQL zone is stored in PGA in dedicated server mode. (Review the concept of PGA: PGA is allocated on the server side and records various connections
Sharing t
I. Overview of Oracle Architecture:Oracle's architecture refers to the composition of the database, the working process and principle, and the Organization and management mechanism of the data in the database. To understand the architecture of the Oracle database, you must understand the important concepts and major components of the Oracle system.The Oracle system architecture consists of three parts: the memory structure, the process structure, and the storage structure. As shown in the follow
Goal
Learn how Oracle Memory management works
Master the way of ASMM management
Master the way of AMM management
Monitor Memory usage
When learning a point of knowledge, it is better to understand its history first. Oracle's recent releases have simplified memory management, from 9i through the Pga_aggregate_target parameters to achieve the PGA automatic management, 10g through automatic Shared memory Management (ASMM) automa
and listens to accept the TCP connection from the client, and obtain the TNS data packets sent from the client. (2) The listening process opens the pipeline for communicating with the sub-process, and fork a sub-process, called "Listening to sub-process 1", and then the listening process keeps waiting, until the "listening sub-process 1" ends. (3) Listen to sub-process 1 Fork out of sub-process 2. (4) After completing the preceding step, child process 1 immediately exits and ends child process
(PGA)
A pga is an exclusive memory area. The Oracle process uses it to store data and control information in a proprietary manner. When the Oracle process starts, the PGA is created by the Oracle database.
User global zone (UGA)
UGA memory allocation is related to user sessions.
Software code area
Part of the memory in this area, which is used to store
Flat package, the Chinese meaning is plastic flat-pack. Chips packaged with this technology also have to use SMD technology to weld the chip to the motherboard. SMD-mounted chips do not have to be punched on the motherboard, generally on the motherboard surface has a design of the corresponding pin pads. The chip can be welded to the motherboard by aligning the pins to the corresponding pads. In this way the chip is welded, if not the use of special tools is difficult to disassemble. The techno
-managed parameter Memory_target in Oracle 11g,It automatically adjusts the SGA and PGA, which requires the/DEV/SHM shared file system to be used.and requirements/DEV/SHM must be greater than memory_target, if/DEV/SHM than Memory_target small will errorSolution Solutions1. Initialization parameters Memory_target or Memory_max_target cannot be greater than shared memory (/DEV/SHM), in order to resolve this problem, you can increase the/DEV/SHMSuch as:#
Take a look at what information this view can bring to us (each column in the view is helpful):[Email protected]> Select pga_target_for_estimate/1024/1024 "PGA (MB)",2 Pga_target_factor,3 Estd_pga_cache_hit_percentage,4 Estd_overalloc_count5 from V$pga_target_advice;PGA (MB) pga_target_factor estd_pga_cache_hit_percentage Estd_overalloc_count---------- ----------------- ----------------------------- -------
Tags: Oracle memory managementThe 6th chapter of Administrator's Guide describes the memory management of Oracle instances, where Oracle uses automatic memory management (AMM) to manage the size of the SGA and PGA by default in 11g. In addition to the default methods, you can use the automatic shared memory management SGA (ASMM), manual shared memory management SGA, automatic PGA Memory management, and manu
the backup and recovery capability of the database, the modified information is archived to archived Log files before overwriting.
Password File : Stores the password when connecting to the backend database system with the client.
The following shows the database portion of Oracle installed on Linux. The large stack of files shown below is Oracle database (typically located under the directory of the instance name under the database installation path).
*.TCL Control files
*.dbf
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.