[oracle@CVS ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 24 13:52:22 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> execute dbms_connection_pool.start_pool();
SQL>execute dbms_connection_pool.alter_param(pool_name => 'SYS_DEFAULT_CONNECTION_POOL',param_name => 'maxsize',param_value => '100');
查看DRCP模式是否启用显示ACTIVE表明已经启用)
SQL> SELECT CONNECTION_POOL, STATUS, MAXSIZE FROM DBA_CPOOL_INFO;
CONNECTION_POOL
------------------------------------------------------------------------------
STATUS MAXSIZE
---------------- ----------
SYS_DEFAULT_CONNECTION_POOL
ACTIVE 100
