Alphabetical list of options
194
ISOLATION_LEVEL option
Controls the locking isolation level.
0, 1, 2, or 3
Can be set for an individual connection or for the PUBLIC group. Takes
effect immediately.
0
1 for Open Client and JDBC connections
This option controls the locking isolation level as follows.
♦
0 Allow dirty reads, nonrepeatable reads, and phantom rows.
♦
1 Prevent dirty reads. Allow nonrepeatable reads and phantom rows.
♦
2 Prevent dirty reads and guarantee repeatable reads. Allow phantom
rows.
♦
3 Serializable. Do not allow dirty reads, guarantee repeatable reads,
and do not allow phantom rows.
$ For more information, see "Isolation levels and consistency" on
page 386 of the book ASA User’s Guide.
JAVA_HEAP_SIZE option
To limit the memory used by Java applications for a connection.
Integer
Can be set for an individual connection or for the PUBLIC group. Takes
effect immediately. DBA permissions are required to set this option for any
connection.
1000000
This option sets the maximum size (in bytes) of the memory that is allocated
to Java applications on a per-connection basis. Per-connection memory
allocations typically consist of the user’s working set of allocated Java
variables and Java application stack space.
While a Java application is executing on a connection, the per-connection
allocations come out of the fixed cache of the database server, so it is
important that a run-away Java application is prevented from using up too
much memory.
Function
Allowed values
Scope
Default
Description
Function
Allowed values
Scope
Default
Description
To Next Page
Loading...