oracle exadata architecture

Today, I started to understand the Oracle architecture and want to write down every part of the learning records. If something goes wrong, please point it out. Thank you. Oracle architecture diagram: Today, I started to understand the Oracle

Label:The interviewer asked me about Oracle's architecture a few days ago, and let me draw it on a blank sheet of paper. Looking back at that time answer is also good, most of the content is described, hehe, just saw an article on the internet to explain the Oracle architecture, feel good, turn around and save, may be used in the future. ========================

1. Oracle memory is composed of SGA+PGA2. 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

,T.extent_management Extman, T.segment_space_management SegmanFrom Dba_tablespaces T,(select Tablespace_name, sum (bytes) allocated, COUNT (file_id) datafiles from Dba_data_files Group by Tablespace_name) d,(select Tablespace_name, sum (bytes) free from Dba_free_space Group by Tablespace_name) F,(select Tablespace_name, sum (bytes) used from Dba_segments Group by Tablespace_name) uwhere T.tablespace_name = D.tablespace_name (+)and T.tablespace_name = F.tablespace_name (+)and T.tablespace_name =

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 sto

Tags: style blog java http tar color1. Several important Oracle TerminologyTo learn about Oracle's architecture, there are a few important terms to understand: Oracle server, oracle instance, Oracle database.Oracle Server: Oracle

Introduction to Oracle Trading Community Architecture (Oracle chloroform)Introduction Oracle Trading Community Architecture (chloroform) is a data model used to manage complex Party or customer information in a business environment, including Organization and Location) and t

side) ggsci> edit params./globalsGgschema GGMCheckpointtable GGM. Ckptabggsci> dblogin userid Ggm,password Oracleggsci> Add checkpointtable Ckptab4.3 Replication process (target side) ggsci> add Replicat Rscott, Exttrail./dirdat/esggsci> Edit Params RscottReplicat RscottUserID Ggm,password OracleHandlecollisionsAssumetargetdefsDiscardfile./dirrpt/rscott.dsc,purgeMap Scott.dept,target scott.dept;4.4 Start Replication (target side) Ggsci>start Replicat RscottGgsci>info Replicat Rscott4.5 Start fe

Tags: c class blog Java a httpLet's take a look at an intuitive picture:Oracle 11gArchitecture DiagramUnderstand the Oracle architecture to fully understand three concepts : database, database instance (instance), session, Be sure not to confuse these three concepts.The concept of a database(A) The physical storage structure consists of data files, control files, redo log files :1. data file (datafile) SEL

Label:Oracle's Best Flexible architecture (Optimal flexible Architecture, referred to as OFA) refers to the naming conventions and storage location rules for Oracle software and database files and folders. It can be used as a good set of habits, which makes it easy for users to find the file structure associated with an Oracl