ttDBWriteConcurrencyModeGet

The ttDBWriteConcurrencyModeGet built-in returns information about the write concurrency mode of the database and the status of write concurrency mode operations and transactions.

Required Privilege

This procedure requires no privilege.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic but not supported in TimesTen Scaleout.

Related Views

This procedure has these related views.

SYS.GV$DB_WRTE_CONCURRENCY_MODE

SYS.V$DB_WRTE_CONCURRENCY_MODE

Syntax

ttDBWriteConcurrencyModeGet()

Parameters

ttDBWriteConcurrencyModeGet has no parameters:

Result Set

ttDBWriteConcurrencyModeGet returns the result set:

Column	Type	Description
`ts`	`TIMESTAMP NOT NULL`	Time at which the status information was collected.
`mode`	`TT_INTEGER` `NOT NULL`	The write concurrency mode: `0` - Optimize according to hints and standard optimization techniques. `1`- Optimize for concurrent write operations.
`operation`	`VARCHAR2 (50)`	The transition status of the write concurrency mode. Either: `NULL` - Not in transition. `TRANSITIONING TO MODE=n` where `n`= `0` or `1`.
`status`	`VARCHAR2 (100) NOT NULL`	The status of the write concurrency mode transition. Either: `IN TRANSITION` or `COMPLETE`.
`msg`	`VARCHAR2 (5000)`	`NULL` or a status explanation message.

Examples

The following example shows how to determine if your database is optimized for concurrent write operations:

CALL ttDBWriteConcurrencyModeGet();

< 2013-09-23 13:48:21.207599, 1, <NULL>, COMPLETE, <NULL> >
1 row found.

The results indicate that at approximately 1:48 pm on September 23, 2013 the database was optimized for concurrent write operations. The mode was not in transition.