ttDataStoreStatus

This procedure returns the list of processes connected to a database. If the dataStore parameter is specified as NULL, then the status of all active databases is returned.

The result set is similar to the printed output of the ttStatus utility.

Required Privilege

This procedure requires no privilege.

Related Views

This procedure has this related view.

SYS.V$DATASTORE_STATUS

Syntax

ttDataStoreStatus('dataStore')

Parameters

ttDataStoreStatus has the parameter:

Parameter	Type	Description
`dataStore`	`TT_VARCHAR (256)`	Full path name of desired database or `NULL` for all databases.

Result Set

ttDataStoreStatus returns the result set:

Column	Type	Description
`dataStore`	`TT_VARCHAR (256) NOT NULL`	Full path name of database.
`PID`	`TT_INTEGER NOT NULL`	Process ID.
`Context`	`BINARY(8) NOT NULL`	Context value of connection.
`conType`	`TT_CHAR (16) NOT NULL`	Type of process connected. The result can be one of the following: `application`: An ordinary application is connected. `replication`: A replication agent is connected. `subdaemon`: A subdaemon is connected. `cache agent`: A cache agent is connected.
`ShmID`	`TT_VARCHAR (260) NOT NULL`	A printable version of the shared memory ID that the database occupies.
`connection_Name`	`TT_CHAR (30) NOT NULL`	The symbolic name of the database connection.
`connID`	`TT_INTEGER NOT NULL`	The numeric ID of the database connection.

Examples

CALL ttDataStoreStatus('/data/Purchasing');