| Option | Description |
|---|---|
| Host | Specifies either the IP address or the hostname of the database server. |
| Port | Specifies the TCP port of the listener running on the database server. The default is 1521, which is the default port number when installing the Oracle database software. |
| User | Defines the user id used to connect to the database. |
| Password | Defines the password for the user id used to connect to the database. This password is case-insensitive. |
| SID | Specifies the Oracle System Identifier that refers to the instance of the Oracle database running on the server. |
| Schema | Optionally, specifies the name of the schema used. Note: When using a schema, it is recommended that the schema name and user name be the same.
|
| URL | Defines the URL format to connect to the database. |
| Option | Description |
|---|---|
| Tablespace | |
| Temporary Tablespace | |
| Profile |
This tab allows you to specify additional properties that are supported by the JDBC driver. Properties are defined using name/value pairs.
| Option | Description |
|---|---|
| Maximum Pool Size | Specifies the maximum number of connections within the connection pool. Database connections are grouped together within a connection pool to improve performance. |
| Maximum connections per user | Specifies the maximum number of connections within the connection pool for each user. |
| Connection Idle Time (minutes) | Specifies how long a connection can be idle before it times out. |
| Minimum Pool Size | Specifies the minimum number of connections with the connection pool. |
| Maximum Opened Cursors | Specifies how many queries can be created for each connection. |