dba_les01_bj

SQL>set wrap off
SQL>set linesize 200
SQL>select * from v$bgprocess;

Connecting to an Oracle instance consists of
establishing a user connection and creating a
session.

9i
SGA is dynamic and sized using SGA_MAX_SIZE;

alter system set db_cache_size=64M;

alter session set nls_language=american;  ***
这样就可以可以查看?????了

dictionary cache = row cache ?不明白

Library Cache is managed by a least recently used(LRU) algorithm
最近最少算法

读是按照db block来读取的,是一个block,一个block来读取的
就算只有一行也是读一个block的

db_cache_size
db_keep_cache_size
db_recycle_cache_size
db_cache_advice

alter system set db_cache_advice=on;

PGA(Program Global Area)
The PGA is memory reserved for each user process
that connects to an Oracle database;

Dedicated server 中 PGA 包括
Stack space
Session information
sort area
cursor information

Shared Server 中 PGA 包括
Stack space
sort area
cursor information
其中 Session information 是放在SGA中的。

Server process:Connects to the Oracle Instance
and is started when a user establishes a session.
and it can be dedicated or shared server.