Databases Reference
In-Depth Information
•
set lock_timeout after
: This is the maximum time a user can maintain
a database lock if idle. The default lock time out is 60 minutes.
Syntax:
alter application <App-Name> set lock_timeout after integer
<MINUTES | SECONDS>;
Code Sample:
alter application 'ESSCAR' set lock_timeout after 75 minutes;
•
set max_lro_file_size
: You can set a maximum file size of an LRO.
This can be either unlimited, or you can specify a file size.
Syntax:
alter application <App-Name> set max_lro_file_size
<UNLIMITED | LRO SIZE>;
Code Sample:
alter application 'ESSCAR' set max_lro_file_size 32768b;
This code sets the maximum LRO file size to 32KB.
•
set type unicode_mode
: You can convert a non-Unicode into a
Unicode mode.
Remember, you cannot convert a Unicode application
to a non-Unicode application. However, you can
convert a non-Unicode application to Unicode.
Syntax:
alter application <App-Name> set type unicode_mode;
Code Sample:
alter application 'ESSCAR' set type unicode_mode;
Using load/unload database
These commands will load and unload the databases into or out of system memory.
Syntax:
alter application <App-Name> load database <Db-Name>;
alter application <App-Name> unload database <Db-Name>;
Code Sample:
alter application 'ESSCAR' load database 'ESSCAR';
alter application 'ESSCAR' unload database 'ESSCAR';
