architecture learning books

power loss, in order to ensure the integrity of the data. Each InnoDB storage engine has at least one redo log group, each group has at least 2 redo log files, such as the default Ib_logfile0 and Ib_logfile1, for greater reliability, you can set up multiple groups, or you can put each group on a different disk to improve performance LSN logsequence Number: Increment produces, can only mark a redo log, for our database recovery is very important, can only locate the database running state, as t

Tags: ble learning entry Good type programming AMP data arc --20170322 --1.0 --Update the statistics of the tableBeginDbms_stats.set_table_stats (user, ' EMP ', numrows = 10000);EndBeginDbms_stats.set_table_stats (user, ' DEPT ', numrows = 10000);End--Re-view the statistics of the tableSelect T.table_name,t.num_rows,t.blocks from User_tables t where T.table_name in (' EMP ', ' DEPT ');/*DEPT 10000 100EMP 10000 100*/ --2.0 --View the number of blocks

Reference: http://blog.chinaunix.net/uid-26119273-id-3356414.htmlLearn Linux, ready to do products, do not regard Linux as the ultimate goal (of course, this is for the application), to have just the idea of Linux as a platform . More important also in a variety of products required by the professional technology , such as communications, such as can, RS485, GPRS and so on, or industrial control, IO control, real-time characteristics and so on. Linxu Broad and profound, research is endless, but

Tags: io using strong file Data SP on C workInstance:is the database service: It can be understood as a service:Multiple processes + memory structureDatabase:Instance + fileRAC: DB cluster　　Multiple instances + files (shared)---at the moment Io is not resolvedMemory structure:Some cache pools, each of which is used by different programs, so you can understand that different functions are placed in different cachesProcess structure:Oracle This software, there are multiple processes work, coordina

The overall structure is divided into three parts: Sga,pga,file fileby function:Storage structureStorage structure Correspondence RelationshipMain documents:Data files: Each data file is associated with only one database A table space can contain one or more data files A data file can belong to only one table space Data files are data that is used to store Chinese in a database Log file: Redo log files: Used to log changes to the database, the user's transactio

Label:There are 4 main architectures for Oracle databases: Physical storage structure Logical storage structure Memory structure Process structure I. Physical storage structureThe Oracle database is physically composed of system files stored on disk, which is the physical storage structure of Oracle.1.1 Data filesA data file is a file that is stored in the data in the database, usually in the *.dbf format. Includes system data, data dictionary data, index data.1.2 Control filesI

Tags: standby oracle change recordDataguard provides two different ways to apply logs to the standby database: Redo apply (physical standby), SQL apply (logical standby).The main goal of DG is to protect database data from loss. Another goal is to provide a high degree of isolation between master and slave libraries.Physical Standby:Redo apply uses the method of media recovery, reads the Redo record from the SRL in memory, and then applies the change vectors directly to recover the data from the

operating environment of Rman consists of several components:650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/70/97/wKioL1W52ebRnSAwAAB3xlvy-ZA465.gif "title=" RMAN Env.gif "alt=" Wkiol1w52ebrnsawaab3xlvy-za465.gif "/>1. Rman ClientA client program that performs Rman backup and recovery operations.2. Target DatabaseDatabases that you want to back up or restore.3. ChannelEach channel represents the data flow from the Oracle server process that is used for Rman backup to a class of stor