Comparing DRCP to Dedicated Server and Shared Server -- DRCP与专有模式和共享模式的比较
Shared Server Data Dictionary Views -- 与共享模式有关的数据字典视图
Configuring Database Resident Connection Pooling -- 配置DRCP
Oracle Database includes a default connection pool called SYS_DEFAULT_
CONNECTION_POOL. By default, this pool is created, but not started. To enable
database resident connection pooling, you must explicitly start the connection pool.
Oracle数据库中默认已有了SYS_DEFAULT_CONNECTION_POOL,但是并未使用。
命令如下:
Issue the following command:
SQL> EXECUTE DBMS_CONNECTION_POOL.START_POOL();
关闭的命令如下:
Issue the following command:
SQL> EXECUTE DBMS_CONNECTION_POOL.STOP_POOL();
Data Dictionary Views for Database Resident Connection Pooling -- 与DRCP有关的数据字典视图
Process and Session Data Dictionary Views -- 与进程和会话有关的数据字典视图
Memory Architecture Overview -- 内存结构的一张图,很清晰
If your database is running on Solaris or Oracle Linux, you can optionally add another
memory component: Database Smart Flash Cache (the flash cache). The flash cache is
an extension of the SGA-resident buffer cache, providing a level 2 cache for database
blocks. It can improve response time and overall throughput, especially for
read-intensive online transaction processing (OLTP) workloads. The flash cache
resides on one or more flash disk devices, which are solid state storage devices that use
flash memory.
如果你使用的操作系统是SOLARIS或LINUX,你还可以使用FLASH CACHE。
You cannot enable automatic memory management if the
LOCK_SGA initialization parameter is TRUE.
这里要注意,当你LOCK_SGA参数是TRUE,你便无使用自动内存管理。
Components and Granules in the SGA -- SGA中的内存分配粒度
If you specify a size for a component that is not a multiple of granule size, Oracle
Database rounds the specified size up to the nearest multiple. For example, if the
granule size is 4 MB and you specify DB_CACHE_SIZE as 10 MB, the database actually
allocates 12 MB.