### Navigation

- index
- modules |
- next |
- previous |
- cx_Oracle 5.1.2 documentation »

# SessionPool Object

Note

This object is an extension the DB API and is only available in Oracle 9i.

`SessionPool.``acquire`()

  Acquire a connection from the session pool and return a connection object (Connection Object).

`SessionPool.``busy`

  This read-only attribute returns the number of sessions currently acquired.

`SessionPool.``drop`(connection)

  Drop the connection from the pool which is useful if the connection is no longer usable (such as when the session is killed).

`SessionPool.``dsn`

  This read-only attribute returns the TNS entry of the database to which a connection has been established.

`SessionPool.``homogeneous`

  This read-write boolean attribute indicates whether the pool is considered homogeneous or not. If the pool is not homogeneous different authentication can be used for each connection acquired from the pool.

`SessionPool.``increment`

  This read-only attribute returns the number of sessions that will be established when additional sessions need to be created.

`SessionPool.``max`

  This read-only attribute returns the maximum number of sessions that the session pool can control.

`SessionPool.``min`

  This read-only attribute returns the number of sessions with which the session pool was created and the minimum number of sessions that will be controlled by the session pool.

`SessionPool.``name`

  This read-only attribute returns the name assigned to the session pool by Oracle.

`SessionPool.``opened`

  This read-only attribute returns the number of sessions currently opened by the session pool.

`SessionPool.``password`

  This read-only attribute returns the password of the user which established the connection to the database.

`SessionPool.``release`(connection)

  Release the connection back to the pool. This will be done automatically as well if the connection object is garbage collected.

`SessionPool.``timeout`

  This read-write attribute indicates the time (in seconds) after which idle sessions will be terminated in order to maintain an optimum number of open sessions.

`SessionPool.``tnsentry`

  This read-only attribute returns the TNS entry of the database to which a connection has been established.

`SessionPool.``username`

  This read-only attribute returns the name of the user which established the connection to the database.

### Navigation

- index
- modules |
- next |
- previous |
- cx_Oracle 5.1.2 documentation »