New features (11g)
Database Resident Connection Pooling (DRCP) : For clients using OCI driver , exec dbms_connection_pool.start_pool;
A pool of pre-allocated connections which can be invoked by a special call in the tnsnames.ora file
Session memory is allocated from the PGA
Flashback Data Archive (FBDA) : Store history of table transactions. create flashback archive near_term tablespace users retention 1 month ; alter table hr.employees flashback archive near_term;
Lightweight Directory Access Protocol (LDAP) :
LDAP is now preferred over Oracle Names
NAMES.DIRECTORY_PATH=(LDAP,TNSNAMES)
DIRECTORY_SERVERS = (fire.gennick.org:389:636)
DIRECTORY_SERVER_TYPE = OID -- AMES.DEFAULT_DOMAIN parameter in sqlnet.ora is ignored
DEFAULT_ADMIN_CONTEXT = "dc=gennick,dc=org" -- cn=OracleContext, which is always added automatically by Net8
Database Resident Connection Pooling (DRCP) : For clients using OCI driver , exec dbms_connection_pool.start_pool;
A pool of pre-allocated connections which can be invoked by a special call in the tnsnames.ora file
Session memory is allocated from the PGA
Flashback Data Archive (FBDA) : Store history of table transactions. create flashback archive near_term tablespace users retention 1 month ; alter table hr.employees flashback archive near_term;
Lightweight Directory Access Protocol (LDAP) :
LDAP is now preferred over Oracle Names
NAMES.DIRECTORY_PATH=(LDAP,TNSNAMES)
DIRECTORY_SERVERS = (fire.gennick.org:389:636)
DIRECTORY_SERVER_TYPE = OID -- AMES.DEFAULT_DOMAIN parameter in sqlnet.ora is ignored
DEFAULT_ADMIN_CONTEXT = "dc=gennick,dc=org" -- cn=OracleContext, which is always added automatically by Net8
