2012-10-21 11gR2 "2DAY DBA" page 73 - 125

 

About Server and Client Processes -- 专有模式与共享模式连接各自使用的地方
Using shared server mode eliminates the need for a dedicated server process for each
user connection, requires less memory for each user connection, and enables more
users to access the database. Shared server mode is more efficient at supporting
multiple client programs making frequent short-running queries.

 

System Global Area -- SGA区中每个池的作用，也算是一个总结了

 

 

About Administration Privileges for Startup and Shutdown
To start or shut down the Oracle instance, you must connect to the instance with a
special connection privilege. There are two of these privileges: SYSDBA for fully
empowered database administrators and SYSOPER for users who start and shut down
the database, but have no privileges to access user objects.

SYSOPER 只有开关机的权限，没有访问用户对象的权限。

 

About Database Storage Structures -- 数据库存储结构的一张图

 

 

About Tablespaces -- 每个表空间作用的总结