SGA : System Global Area

查看sga

SQL>show sga;

Sga sized by the SGA_MAX_SIZE prarmeter.

Select component,granule_size from v$sga_dynamic_components;

Shared Pool:

1. library cache
2. date dictionary cache

database buffer cache:

Redo log buffer:

Large pool:

Java pool:

-----------------------------------------------------------------------------------------------

PGA: program Glob Area

Process structure

1. user process
2. server process
3. Background process

 

IPC  & TCP/IP

Ipc :inter process communication,包括共享内存、队列、信号量等几种形式。

To start Universal Installer in non-interactive mode:

./runInstaller –responsefile myrespfile –silent

User SYS:

       Owner of the database data dictionary

       Default password:change_on_install

User system:

       Owner of additional internal tables and views used by oracle tools

       Default password: manager