1 We just open the Alipay can see the main interface has a "lottery", click on it after we click it into the "my Lottery." (pictured below)
2 Enter the interface will be able to see my purchase lottery record and purchase lottery records,
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 parallel Parameters
Use manual pga at the session level and manually adjust sort_area_size
Modify other parameters
Note: hash_area_size is not adjusted manually here. By default, hash_area_size is automatically
The following articles mainly describe the actual application of Process Memory in the Oracle storage structure. We all know the actual application processes of Oracle except for the SGA (System Global Area, the following three global zones are also frequently used:
The Process Global Area (PGA );
The User Global Area (UGA );
The Call Global Area (CGA ).
Many people do not know the difference between PGA
The following articles mainly introduce the Process Memory in the Oracle Memory structure. This article describes the Process Memory in the Oracle Memory structure. If you are an Oracle enthusiast. The following article will be meaningful to you.
Process Memory in Oracle Memory Structure
The Process Memory, in addition to The SGA (System Global Area), The Oracle Process also uses The following three Global zones:
The Process Global Area (PGA );
The
Oracle
The Process Memory:
In addition to the SGA (System Global area), the Oracle process also uses the following three global zones:
The Process Global area (PGA)
The User Global area (UGA)
The call Global area (CGA)
A lot of people don't know the difference between PGA and UGA, in fact, the difference between the two is similar to the difference between a process and a session. Although it is genera
Basic information Situation:DB version: Oracle database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionOperating system version: CentOS release 5.6Speed up index creation the main consideration is from the point of view:
Using the nologging parameter
Using parallel parallel parameters
Use the manual PGA at the session level to manually adjust the Sort_area_size
Modify other parameters
Note : We do not manually adju
Welcome to the Oracle community forum and interact with 2 million technical staff to enter the PGA (ProcessGlobalArea), a private memory zone of serverprocess, which contains global variables, data structures, and some control information. In Oracle8i, PGA adjustment is very complex. You need to adjust SORT_AREA_SIZE, HASH_AREA_SIZE, BITMAP_MERGE_A
Welcome to the Oracle Community Forum, interact with 2 mill
. The SGA database activity in each zone can be monitored independently, and resources can be allocated and retrieved according to the pattern used in the Oracle database.
Let's first look at some of the differences between the following Oracle9i database and the Oracle8i database. One of the most important oracle9i is that there is no need to have a separate PGA space for all the dedicated connections to the Oracle database. In Oracle8i, for a dedic
Ask a regular expression of the problem, urgent urgent ~
Want to do a news gathering program, using curl to collect the HTML code
I want to use regular expressions to split up the data I need.
For example:
Keywords: mustard diet
Shepherd's Purse, also known as Incense camelina, ling, cabbage, Ching Ming cuisine, is a kind of light green flowers of the herb, is not only delicio
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
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
cholesterol and also protect the eyes.Eye dry eye astringent eye tired eat what good?Dry eyes eat Shepherd's PurseChinese folk known as the "lunar March three, shepherd's purse race a panacea", many elderly people will eat at this time and shepherd's purse related dishes, this shows the medicinal efficacy of shepherd's purse. Spring and autumn Warring States Per
.
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.
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
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.