When sorting, grouping and summarizing, and indexing are performed in the Oracle database, a lot of temporary data is generated. If there is an employee information table, the database stores the installation record creation time.
When sorting, grouping and summarizing, and indexing are performed in the Oracle database, a lot of temporary data is generated. If there is an employee information table, the database stores the installation record creation time.
If you use the Order BY sorting state
.
(4) After completing the preceding step, child process 1 immediately exits and ends child process 1.
(5) sub-process 2 collects the host name, IP address, and process Number of the process, the sub-process 2 is renamed as the server process (here we also call the server process as the frontend process or server process), and the application occupies a small piece of PGA memory.
(6) The foreground process sends the host name, IP address, and pr
The new feature of ORACLE11G's automatic memory management (Automatic Memory Management) is another important enhancement of Oracle's memory management. If this parameter is set too high, the following error prompts may appear when the instance is started:
SQL*Plus: Release 11.1.0.5.0 - Beta on Sun Jul 29 08:35:28 2007 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORA-00845: MEMORY_TARGET not supported on this system
This tip does not mean t
When sorting, grouping and summarizing, and indexing are performed in the Oracle database, a lot of temporary data is generated. If there is an employee information table, the database stores the installation record creation time. If you use the Order BY sorting statement to specify the Order BY employee number, all records generated after sorting are temporary data. How does the Oracle database process the temporary data?
Generally, the Oracle database first stores the temporary data in the
of disk space, Oracle is using a greedy algorithm, if the last disk space consumption reached 1GB, then the temporary table space is 1GB. That is, the size of the current temporary tablespace file is the maximum size of a temporary table space used historically. Primary role of temporary tablespace: index create or rebuild order by or group by DISTINCT operations Union or intersect or minus Sort-merge joins
***************************************************************************************
When sorting, grouping, and indexing are done in an Oracle database, a lot of temporary data is generated. If you have a table of employee information, the database is the time to set up records to save. If a user queries by using the ORDER by sort statement to specify the sort by employee number, all the records that are created after sorting are temporary data. What do Oracle databases do with these temporary data?
Typically, Oracle databases first store these temporary data in the
When sorting, grouping, and indexing are done in an Oracle database, a lot of temporary data is generated. If you have a table of employee information, the database is the time to set up records to save. If a user queries by using the ORDER by sort statement to specify the sort by employee number, all the records that are created after sorting are temporary data. What do Oracle databases do with these temporary data?
Typically, Oracle databases first store these temporary data in the
If a user queries by using the ORDER by sort statement to specify the sort by employee number, all the records that are created after sorting are temporary data. What do Oracle databases do with these temporary data?
Typically, Oracle databases first store these temporary data in the PGA (Program Global Area) of memory. In this program global area there is a place called the sort area, which is designed to hold these temporary data generated by the so
sort operation. Typically, Oracle sorts operations in the following situations:1. When you create an index2. Using ORDER BY3. Use GROUP BY4. When a table join occurs, the SQL optimizer calls the merge sort because of insufficient existing indexesWhen a session is established in an Oracle instance, a private sort area is assigned to the session in memory. If the connection is a private connection, a PGA is allocated in memory based on the size of the
Label:First, Introduction:Oracle 9i introduces Pga_aggregate_target to automatically adjust the PGA;Oracle 10g introduces Sga_target to automatically adjust the SGA;Oracle 11g combines these two parts, introducing Memory_target, which automatically adjusts all memory, which is the newly introduced automatic memory management feature.Second, this article explains:Operating system: Rhel 5.4 x32Database: Oracle 11g R2Iii. Introduction of Memory_target:3.
Welcome to the Oracle community forum and interact with 2 million technical staff. AutoMemoryManagement is a new feature proposed by Oracle10g. It has been further developed in the latest Oracle11g database. By using automatic memory management, the PGA and SGA memory in the Oracle database can be converted to each other based on the current workload.
Welcome to the Oracle community forum and interact with 2 million technical staff> Entering Auto Memo
between the chip area and the encapsulation area is small.
80286, 80386, and some 486 boards in Intel series CPUs use this encapsulation form.
3. PGA plug-in Grid Array Encapsulation
The PGA (PIN Grid Array package) chip is encapsulated in the form of multiple matrix-shaped pins inside and outside the chip. Each matrix-shaped pin is arranged at a certain distance between the four sides of the chip. T
2 hours after the database is started, you can use the following SQL to test the database performance.
1. Buffer hit rate:
Buffer hit rate indicates the frequency of finding common data blocks in the memory structure without disk access.
Select (1-(sum (decode (name, 'Physical reads', value, 0)/(sum (decode (name, 'db block gets', value, 0 ))+ Sum (decode (name, 'consistent gets', value, 0) * 100 "hit ratio"From v $ sysstat;
98% or more is the best
2. Data Dictionary cache hit rate:
The cache
I'm in http://zhidao.baidu.com/question/123262452.html? I am very grateful to zw.ssg for sorting out the questions raised by Fr = MSG.Answer
Sorting memory involves PGA.When can I use automatic PGA memory management? When can I use manual PGA memory management?
Automatic PGA memory management is suitable for normal system operation during the day, allowing Oracl
Oracle technical Q
Today, I talked to a senior Oracle expert about a lot of technical problems. He also came up with a few questions and asked me at random, I found that there are still a lot of dry goods in the seemingly simple questions. Many things seem to understand or not understand them in depth. Due to space limitations, I sorted out some questions and answered some questions correctly, however, I feel that my understanding is not clear enough.
Log buffer
Functions of log buffer
Logbuffe
Generally, we will use the memory of the oracle instance to 80%-60% of the system's physical memory (4 GB memory or above used more than 80%, 2 GB memory used 60%-70%) spga + sga_max_size80 % mem
Generally, we will use the memory of the oracle instance to 80%-60% of the system's physical memory (4 GB memory or above used more than 80%, 2 GB memory used 60%-70%) s = pga + sga_max_size = 80% mem
Generally, we will use the memory of the Oracle insta
large storage space that is reserved for data at one one-time.Block: Oracle's most basic storage unit, specified when establishing a database.
3. Memory allocation (SGA and PGA)
SGA: The memory area that is used to store database information that is shared by the database process. It contains data and control information for the Oracle server, which is allocated in real memory on the computer where the Oracle server resides, if the actual memory is n
1. Database version
Leo1@leo1>select * from V$version;
BANNER
--------------------------------------------------------------------------------
Oracle database11g Enterprise Edition release 11.2.0.1.0-64bit Production
Pl/sql release11.2.0.1.0-production
CORE 11.2.0.1.0 Production
TNS for Linux:version 11.2.0.1.0-production
Nlsrtl version11.2.0.1.0-production
2. Set the Memory_target parameter and analyze the optimal memory size of the database by V$memory_target_advice
Memory_ Target:1.
to hold the secondary database and the data pump files.2) A full database backup must exist, or at least the system-related tablespace exists.The following restrictions apply to the Rman recovery table or partition:1) SYS user table or partition cannot be recovered.2) tables or partitions stored in the Sysaux and system table spaces cannot be recovered.3) You cannot use the Remap option to restore a table that contains a NOT NULL constraint.10. Limit PGA
Label:Oracle Database creates and uses memory structures for various purposes. For example, memoryStores program code being run, data, was shared among users, and private data areas for eachConnected user.Both basic memory structures is associated with an instance:•System Global Area (SGA): Group of shared memory structures, known as SGAcomponents, which contain Dataand control information for one Oracle Database instance.The SGA is a shared by all server and background processes. Examples of da
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.