5. SessionPool Objects
NOTE: This object is an extension the DB API and is only available in
Oracle 9i.
-
Acquire a connection from the session pool and return a connection
object (2).
- busy
-
This read-only attribute returns the number of sessions currently acquired.
- dsn
-
This read-only attribute returns the TNS entry of the database to which a
connection has been established.
- increment
-
This read-only attribute returns the number of sessions that will be
established when additional sessions need to be created.
- max
-
This read-only attribute returns the maximum number of sessions that the
session pool can control.
- 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.
- name
-
This read-only attribute returns the name assigned to the session pool by
Oracle.
- opened
-
This read-only attribute returns the number of sessions currently opened by
the session pool.
- password
-
This read-only attribute returns the password of the user which established
the connection to the database.
-
Release the connection back to the pool. This will be done automatically as
well if the connection object is garbage collected.
- 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.
- tnsentry
-
This read-only attribute returns the TNS entry of the database to which a
connection has been established.
- username
-
This read-only attribute returns the name of the user which established the
connection to the database.
Release 4.1beta1, documentation updated on 31 August 2004.