RESERVE_SESSION_RESOURCE

Reserves memory resources from the general resource pool for the exclusive use of the backup and restore process.

Reserves memory resources from the general resource pool for the exclusive use of the backup and restore process. No other OpenText™ Analytics Database process can access reserved resources. If insufficient resources are available, the database queues the reservation request.

This meta-function is a session level reservation. When a session ends, the database automatically releases any resources reserved in that session. Because the meta-function operates at the session level, the resource name does not need to be unique across multiple sessions.

You can view reserved resources by querying the SESSIONS table.

This is a meta-function. You must call meta-functions in a top-level SELECT statement.

Behavior type

Volatile

Syntax

RESERVE_SESSION_RESOURCE ( 'name', memory)

Parameters

name: The name of the resource to reserve.
memory: The amount of memory in kilobytes to allocate to the resource.

Privileges

None

Examples

Reserve 1024 kilobytes of memory for the backup and restore process:

=> SELECT reserve_session_resource('VBR_RESERVE',1024);
   -[ RECORD 1 ]------------+----------------
   reserve_session_resource | Grant succeed