or linux32-bit operating system, you must set the shmmax parameter of the operating system level. The space of SGA can be larger than shmmax. For details, refer to the Oracle Installation manual and operating system manual;
NOTE 2: operations listed in this section (below) may require certain permissions. In actual work, if you find problems with related permissions, authorize the relevant user in time or operate as a user with a higher permission.
Shows the overall Oracle memory structure:
The
Now the industry of mobile payment is very chaotic, there are many legal and competitive payment methods, countless startups, industry giants, banking institutions, joint ventures and so on want to share from this market. In the big companies, the deer dominate the role of the time, consumers must wait for the change and patience.
In the past few years, we have seen Square, Google, Intuit and other companies have issued a unique e-wallet. While mobile payments are the highlight of this year's C
Oracle Architecture Diagram 1Oracle Architecture Diagram 2
User process (The generic name of the client that accesses Oracle)Use of tools: sqlplus, PL/SQL developerHow to access the database:This machine is accessed directly via sock (IPC Access-UDP Protocol) (Sqlplus/as SYSDBA).Establish a server connected to Oracle via TCP (Sqlplus Sys/[email protected] as SYSDBA) (Sqlplus sys/[email protected]:[email Protected]_name as sysdba--access to this method requires that the Listener.o
Automatic Memory Management type
Automatic Memory Management: New Features of Oracle 11g, allowing the database to fully automatically manage memory SGA and PGA Components
Automatic shared memory management: If this option is selected, SGA can be automatically managed, but PGA cannot be automatically managed.
Automatic PGA memory management: This option can o
Oracle mass data accelerates index creation. database version: OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0
Oracle mass data accelerates index creation. Database version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
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 para
************----Sum 4194304
Shared Pool 1: kngisga 16044X $ ksmfs table 12X $ rule_set 16804
......Xscalc 3528Xslongops 4040Xsoqmehift 4168Xsoqojhift 3272Xsoqophift 4168Xsoqsehift 2376Xssinfo 5532************----Sum 113250900
Buffer_cached 46137344Fixed_sga 1260696Log_buffer 2932736************----Sum 50330776
1.2 SGA features
1) in Unix systems, SGA represents an independent physical entity in the operating system, that is, an independent shared memory segment, you can use IPCS-M | grep Ora to
.
Select event, total_waits, time_waited, average_wait from v $ system_event where event like 'Log file switch (arch % ';
If there is a wait, check whether the storage device that saves the archived logs is full. Add a log file group and adjust log_archiver_max_processes.
F. DB_block_checksum = true, which increases the performance burden. (To ensure data consistency, add a checksum to the block when writing data in oracle, and verify the checksum when reading data)
2. java pool
For large a
Oracle memory management (one)
[In-depth analysis of oracle-eygle] Study Notes
1. Memory Management
The memory used by the ORACLE database mainly involves two aspects: PGA and SGA.1.1 PGA Management
PGA refers to the Program Global Area, which is a memory Area used by the Server Process to contain data and control information.
"Deep analysis Oracle-eygle" study notes1. Memory ManagementThe memory used by the Oracle database involves two main areas: the PGA and the SGA.1.1 PGA ManagementThe PGA refers to the program global Zone, which is the area of memory used by the server process to contain data and control information, the PGA is non-shar
Before assigning the appropriate size to the database with the new automatic memory management feature, you must first find the current amount of memory allocated to SGA and PGA. But it does not mean that sga _
Before assigning the appropriate size to the database with the new automatic memory management feature, you must first find the current amount of memory allocated to SGA and PGA. But it does not mean
Analysis of ORA-04030 in alert logs
Yesterday I went to a customer to do inspection, encountered a classic ora-04030 error, alert Log is as follows:
Tue Oct 28 09:57:46 2014Errors in file/Oracle/app/oracle/diag/rdbms/wmsdb/trace/wmsdb_ora_33358038.trc (incident = 177302 ):ORA-04030: out of process memory when trying to allocate 118808 bytes (QERHJ hash-joi, kllcqas: kllslibs)Incident details in:/oracle/app/oracle/diag/rdbms/wmsdb/incident/incdir_177302/wmsdb_ora_33358038_i177302.trcErrors in fil
not the swap space, effectively improving the database efficiency But it will increase the startup time of the database.Set Memory LockConfiguring the Limits.conf fileVi/etc/security/limits.conf added or modified to the following:Oracle Soft Memlock-1Oracle Hard Memlock-1Note:-1 is not limited, if set, the Memlock data is larger than the number of large pages of memoryView Changes(Oracle User)Ulimit-lModifying ParametersSqlplus/as sysdbasql>alter System Set LOCK_SGA = True Scope=spfile; Sql>alt
The 3D Authentication Service is a credit card online payment security Verification service which is jointly launched by the bank and Visa and MasterCard International to protect bank Visa and MasterCard credit card customers online transaction, and to protect against online counterfeiting transactions (the authentication service used by Visa is called " Verified by VISA "VbV", the authentication service u
Definiti 1728
Shared Pool Trigger Defini 1896
Shared pool trigger Inform 1140
Shared Pool Trigger Source 448
Shared Pool type Object de 69120
Shared pool Checkpoint Queue 282304
Shared pool VIRTUAL Circuits 265160
Shared Pool Dictionary Cache 1610880
POOL NAME BYTES
----------- -------------------------- ----------
Shared pool KSXR receive buffers 1033000
Shared pool Character Set object 323724
Shared Pool Fileidentificatonblock 323292
Shared pool message Pool Freequeue 834752
Shared pool KSXR
When using alsa_amixer controls, in addition to the kcontrols added by snd_soc_add_controls we mentioned earlier, there are also some extra controls. In fact, all the others are dapm kcontrol, which is mainly used to switch the audio path.
I. Audio paths Overview
Take the standard kernel 2.6.32 wm8900 codec as an example. First look at audio paths overview. The red line isLinput1 (left input)-> left input PGA-> left input mixer-> left output mix
Tags:load get technology Records read Data Modify protect ima status change The client SQL plus requests the connection, listens to the TCP connection that accepts the client, and obtains the TNS packet sent by the client. The listening process opens the pipeline used to communicate with the child process, while fork a child process, called a child process that listens to child process 1, and then the listener process waits until the "listener subprocess 1" ends. Listen for sub-process 1 f
Tags: failed to submit SSI www. Control file Save view binary CREATE table1. Oracle memory is composed of SGA+PGA 2. Oracle Database ArchitectureDatabase architecture refers to the composition, working process and principle of database, and the organization and management mechanism of data in database. How Oracle Works: 1), start the Oracle instance on the database server;2), the application runs in the client's user process, enabling the Oracle Ne
Label:Memory structureIn modern computers, the CPU accesses memory more than a few times faster than the disk, so Oracle accesses the data as much as possible in memory, rather than directly modifying the data on the hard disk. Memory content is synced to disk at the right time. Oracle uses memory to overcome the constraints of disk IO, the more activity in memory, the better the system performance, conversely, the more operations on disk, the system performance is worse. (Original address: http
When an Oracle database instance is started, it needs to allocate shared memory to start background processes.
The memory used by the Oracle database mainly involves PGA and SGA.
1. PGA
Program global area, as the name suggests, is the global area of the program. It is a memory area used by the server process to contain data and control information. PGA is non-sh
Five, Oracle performance optimization under LinuxOptimization of Oracle Database memory parametersOracle-related system kernel parametersSGA, PGA parameter settingsOracle down-disk storage performance Optimizationfile System Selection (EXT2/EXT3, XFS, OCFS2)Oracle ASM Storage1. 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 i
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.