ttStatus
Displays information that describes the current state of TimesTen.
The command displays:
-
State of the TimesTen daemon process and all subdaemon processes.
-
Names of all existing TimesTen databases.
-
Number of connections currently connected to each TimesTen database.
-
The RAM, cache agent and replication policies.
- The status of the start up scripts and which command needs to be used to start the daemon.
-
TimesTen cache agent status.
-
The status of PL/SQL.
-
The key and address of the shared memory segment used by TimesTen.
-
The address, key and ID of the shared memory segment used by PL/SQL.
-
Whether the TimesTen instance is accessible by a specified operating system group or accessible by anyone. For more details, see the daemon options in the Managing TimesTen Daemon Attributes in Oracle TimesTen In-Memory Database Operations Guide.
-
Miscellaneous status information.
If you specify a connection string or DSN, ttStatus
outputs only the information for the specified database.
Required Privilege
This utility requires no privileges.
Usage in TimesTen Scaleout and TimesTen Classic
This utility is mainly for use in TimesTen Classic. You can only use it for TimesTen Scaleout to retrieve information about the local instance.
Syntax
ttStatus {-h | -help | -?} ttStatus {-V | -version} ttStatus [-v] [-r secs] [-[no]pretty] [-gridbrief] ttStatus [-r secs] [-[no]pretty] {DSN | -connStr connection_string}
Options
ttStatus
has the options:
Option | Description |
---|---|
|
Prints usage information and exits. |
|
Prints the release number of |
|
An ODBC connection string that specifies a database location, driver, and optionally other connection attribute settings. |
|
An ODBC data source name of the database for which to get status. |
|
Prints detailed information that is useful for TimesTen customer support. |
|
Enables |
|
The |
|
Removes the lists of connections for every existing database or element from the displayed information. |
Sample Output
When you call the procedure, a report that describes the current state of the system is displayed to stdout
. To get the status for the cachedb1_18110
DSN:
% ttstatus cachedb1_18110 TimesTen status report as of Thu May 02 19:45:43 2013 Daemon pid 5280 port 53392 instance tt1811 TimesTen server pid 3940 started on port 53393 ------------------------------------------------------------------------ Open for user connections Data store cachedb1_18110 There are 12 connections to the data store Shared Memory KEY Global\cachedb1_18110.c|. . .HANDLE 0x254 PL/SQL Memory KEY Global\cachedb1_18110.c|. . . HANDLE 0x258 Address 0x5B8C0000 Type PID Context Connection Name ConnID Process 5196 0x01066a58 cachedb1_18110 1 Subdaemon 3912 0x00b2c398 Manager 2047 Subdaemon 3912 0x00b7e4a0 Rollback 2046 Subdaemon 3912 0x015d25e8 Flusher 2045 Subdaemon 3912 0x015e46b0 Monitor 2044 Subdaemon 3912 0x016767f8 Deadlock Detector 2043 Subdaemon 3912 0x016888c0 Checkpoint 2041 Subdaemon 3912 0x0d350578 Aging 2042 Subdaemon 3912 0x0d362640 Log Marker 2040 Subdaemon 3912 0x0d4347c8 AsyncMV 2039 Subdaemon 3912 0x0d446890 HistGC 2038 Subdaemon 3912 0x0d458958 IndexGC 2037 Replication policy : Manual Cache Agent policy : Manual PL/SQL enabled. ------------------------------------------------------------------------ Accessible by group . . . End of report
Notes
-
While primarily intended for use by TimesTen customer support, this information may be useful to system administrators and developers.
-
The
ttStatus
utility only reports the RAM policy if it is notinUse
.
See Also