oracle arcn 参数,Oracle 体系结构组件

SGA DBWnLGWRCKPT PMONSMON ARCn

SQL Oracle

Oracle Oracle Oracle SQL Oracle Oracle Oracle Oracle Oracle (SGA) Oracle Oracle / (I/O) Oracle Oracle Oracle SQL SQL (Advanced Queuing) (Real Application Clusters) (Shared Server) (Advanced Replication)

Oracle Oracle Oracle (SGA) Oracle SQL SQL*Plus Oracle Forms Oracle Oracle Oracle SQL Oracle Oracle Oracle Oracle / Oracle Oracle NT NT UNIX Oracle Oracle Oracle Oracle (Shared Server)

Oracle Oracle Oracle Oracle Oracle SGA Oracle Oracle (SGA) SGA Oracle Oracle SGA SQL> SHOW SGA:Total System Global Area36437964 bytesFixed Size 6543794 bytesVariable Size 19521536 bytesDatabase Buffers 16777216bytesRedo Buffers 73728 bytes SGA: Oracle9i SGA SGA SGA_MAX_SIZE SGA SGA SGA DB_CACHE_SIZE UNIX 48 MB NT 52 MB LOG_BUFFER SHARED_POOL_SIZE SQL PL/SQL 16 MB 64 64 MB LARGE_POOL_SIZE init.ora PARALLEL_AUTOMATIC_TUNING TRUE JAVA_POOL_SIZEJava 24 MB SGA SGA_MAX_SIZE - DB_CACHE_SIZE - LOG_BUFFER SHARED_POOL_SIZE - LARGE_POOL_SIZE - JAVA_POOL_SIZE Oracle9i SGA

SGA SGA_MAX_SIZE SGA 128 MB 4 MB 16 MB ALTER SYSTEM ALTER SYSTEM V$BUFFER_POOL Oracle SGA_MAX_SIZE SGA SGA Oracle SQL PL/SQL SHARED_POOL_SIZE ALTER SYSTEM SET SGA SGA_MAX_SIZE LRU SQL PL/SQL SQL SQL SQL SQL SQL SQL SQL PL/SQL PL/SQL PL/SQL SQL

Oracle Oracle LRU Oracle DB_BLOCK_SIZE DB_BLOCK_SIZE SYSTEM DB_CACHE_SIZE DB_KEEP_CACHE_SIZE DB_RECYCLE_CACHE_SIZE INSERTUPDATEDELETE CREATEALTER DROP LOG_BUFFER Oracle9i Oracle XA Oracle SQL SQL I/O SQL BACKUP_DISK_IO= n BACKUP_TAPE_IO_SLAVE = TRUE (RMAN) RMAN I/O PARALLEL_AUTOMATIC_TUNING TRUE

LARGE_POOL_SIZE LRU LRU LRU

Java Java Java Java Java JAVA_POOL_SIZE Oracle9iJava 24 MB

(PGA) (PGA) PGA SGA PGA PGA PGA PGA SQL SQL SQL SQL SQL SQL SQL SQL SQL INSERTUPDATE DELETE SQL SQL SQL PGA SQL SGA SQL SQL OPEN_CURSORS 50 SQL Oracle9i WORKAREA_SIZE_POLICY AUTO PGA_AGGREGATE_TARGET DBA PGA_AGGREGATE_TARGET PGA DBA *_AREA_SIZE Oracle9i DBA SQL SORT_AREA_SIZEHASH_AREA_SIZEBITMAP_MERGE_AREA_SIZE CREATE_BITMAP_AREA_SIZE

PGA PGA

Oracle SQL*Plus Oracle (UPI) Oracle (OPI) Oracle Oracle9i

Oracle Oracle ARCn RECO QMNn ARCn LCKn RAC LMONRAC DLM LMDnRAC DLM CJQ0 Dnnn Snnn Pnnn

(DBWn)DBWn DBWn , (Real Application Clusters, RAC) ping ALTER TABLESPACE BEGIN BACKUP (LGWR)LGWR 1 MB DBWn LGWR LGWR DBWn

(SMON) Oracle SGA SMON 1. SGA SMON 2.3. SMON SMON (PMON) PMON Oracle9i II

(CKPT)CKPT DBWn Oracle9i CKPT CKPT CKPT (ARCn) ARCn Oracle ARCn DBA DBA ARCHIVELOG NOARCHIVELOG NOARCHIVELOG NOARCHIVELOG LGWR SGA

ARCHIVELOG ARCHIVELOG ARCHIVELOG Oracle9i II

Oracle Oracle Oracle

Oracle Oracle SYSTEM Oracle Oracle Oracle DBA Oracle Oracle Oracle Oracle Oracle Oracle Oracle DB_BLOCK_SIZE I/O

SQL

SQL DML DML DELETE INSERT DELETE INSERT DDL DDL DML DDL SQL SQL SQL