本文介绍了Oracle数据库中专有模式与共享模式连接的区别，共享模式能够支持更多用户并发访问，并适用于频繁短时查询的场景。此外，还概述了启动和关闭数据库所需的SYSDBA和SYSOPER权限区别，以及数据库存储结构和表空间的作用。
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 -- 每个表空间作用的总结
扫一扫
826
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
