Specifying PL/SQL Connection Attributes in a DSN

For TimesTen, PL/SQL connection attributes exist both as first and general connection attributes.

• PLSQL_MEMORY_ADDRESS - A first connection attribute that specifies the virtual address, as a hexadecimal value, at which the PL/SQL shared memory segment is loaded into each process that uses the TimesTen direct drivers. This memory address must be identical in all connections to your database and in all processes that connect to your database.

• PLSQL_MEMORY_SIZE - A first connection attribute that determines the size, in megabytes, of the PL/SQL shared memory segment.

• PLSCOPE_SETTINGS - A general connection attribute that controls whether the PL/SQL compiler generates cross-reference information.

• PLSQL_OPTIMIZE_LEVEL - A general connection attribute that sets the optimization level that is used to compile PL/SQL library units.

This example creates the PLdsn DSN and sets the PL/SQL shared memory segment size to 32 MB.

[PLdsn]
Datastore=/disk1/databases/PLdsn
PermSize=128
DatabaseCharacterSet=AL32UTF8
ConnectionCharacterSet=AL32UTF8
PLSQL_MEMORY_SIZE=32
CacheAdminWallet=1

For more examples and a complete list of PL/SQL connection attributes see PL/SQL Connection Attributes in Oracle TimesTen In-Memory Database PL/SQL Developer's Guide.