oracle exadata architecture

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 of data occupied by the index, cluster factor

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

starting or shutting down statistics. (3.) Redo Log Cache When the user performs the Insert,update,delete,create,alter and drop operations, the data changes, and these changes in the rate of data are written to the redo log before they are written to the database cache. Storage area, and the data before the change is also put into the Redo log cache area, so that when data is restored, Oracle knows which ones need to roll forward and what needs to be

for Oracle databases under Linux:$ps-ef|grep Ora_Oracle logical Structure of a database:an Oracle database consists of one or more tablespace (tablespaces)---> Each tablespace contains multiple or one segment (segments)----> Each segment (segment) contains one or more extent (zones)----> each extent (Zone) contains one or more blocks.Oracle's Tablespace (table space) consists of one or more data files.View

Tags: OracleOracle is designed to be a very portable database software that can be run more stably, whether in Linux,unix or Windows download, and is supported on mainframes. This blog is only used to document the initial understanding of Oracle architecture when a person first learns oracle, and if there is a shortage, I hope you will correct it.Databases and in

I still want to worry about it. If you want to learn the Oracle architecture thoroughly, you must learn it based on the backup and recovery experiments and principles. I will also write a blog later. Here I am introducing the memory structure, just to do some basic understanding. Let's first look at two confusing concepts. There is no essential difference between Sid and oracle_sid. If you really want to sc

The Oracle architecture includes the basic concepts of Oracle databases and instances. If you want to understand the Oracle architecture, you must understand these two basic concepts, the following is a detailed introduction of the article. I hope you will gain some benefits

logical replication, the Oracle goldengate implementation principle is to extract the source side of the redo log or archive log, and then post to the target via TCP/IP, and finally resolve the restore application to the target side, so that the target side to achieve homologous data synchronization. The following is the technical architecture of Oraclegoldengate:Manager ProcessThe manager process is a gol

10 Gb. alter table t shrink space; However, row movement) alter table t shrink space; In this way, we can compress... Check whether row movement can be moved. select * from dba_tables where table_name='T'; ========================================================== ====================================== Move Table t to table space 2 to observe the changes. alter table t move tablespace orcl02; Case 1: ? Optimize the problem and observe the disk read rate and the reading st

Tag:recoverota contains library files over global change mode src I. Oracle DATABASE ArchitectureThe architecture consists of the following components:1. Oracle server: Consists of a database instance and a database file, and initiates a server process and assigns the PGA (Program Global Zone) when the user establishes a connection to the server(1) DB instance

[IT168 technical documentation] 1. Introduction Today's IT environment is experiencing dramatic changes, and companies that rely on a single relational database management system (RDBMS) to manage data are gradually decreasing. Analysts report that more than 90% of companies today have more than one RDBMS. In the current tense economic situation, the actual needs are challenging the limits of IT staff. It is increasingly rare for a company to assign different DBAs to manage each RDBMS. Today, DB

To understand the Oracle architecture, you must first understand two basic concepts: databases and instances. 　　I. Database A database is a collection of data. Whether the database adopts a relational structure or an object-oriented structure, the Oracle database stores the data in the data file. internally, the logical ing of database structure data to files al

there is a delay between the nodes, the broadcast although the load, but there is no delay. The Oracle 10g RAC defaults to the broadcast algorithm, which you can see from the Alert.log log:Picked broadcast on commit scheme to generate SCNSRedolog Checkpoint and SCN relationshipsHttp://blog.csdn.net/tianlesoftware/archive/2010/01/25/5251916.aspx2.5 Cache Fusion, GCS, GES relationshipCache fusion (Memory fusion) is a data block transfer between instanc

Tags: data dictionary TE Single Instance PGA blog update is caching aInstall Oracle software----Create a database----create tables in the database----table stores information---these table files need to be stored on the physical hard disk.If a user (the user can be a remote user, or a local or an application) is connected to the Oracle database, the user is not directly connected to the data file stored on

The previous sections mainly focus on some features and management methods of Oracle software. Oracle is a large set of system software. It is about Oracle installation and deployment. I will not describe how to deploy configurations first, because this involves a lot of technologies and content. This article only describes Oracle's configurable

By studying databases and instances, we can know that the Oracle architecture can be divided into three categories: the internal structure of the database (such as tables), the internal structure of the storage area includes the shared storage area and process) and the external structure of the database. I. Internal Structure in Oracle ArchitectureThe internal st

I. ORACLE Physical Architecture Principle Structure diagram Each part explains:PGA: Private memory area for use by the current initiating user only.Three effects The session information after the user logs in will be saved in the PGA. perform a sort , and if memory is not enough, Oracle will do it in a temporary tablespace Save User

FilesRedo log is actually a very important thing, redo is usually specified when building a library.selectfrom v$logTurn on archive mode1. See if it is in archive mode:loglistlog mode No Archive ModeAutomatic archival DisabledArchive destination /u01/app/oracle/product/11.2.0log sequence 36log sequence 382. Backing Up the database3. Edit PfileLOG_ARCHIVE_DEST="/u01/app/oracle