ttStatus

Description

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 data stores.
Number of users currently connected to each TimesTen data store.
The RAM, cache agent and replication policies.
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 options" in the Oracle TimesTen In-Memory Database Operations Guide.
Miscellaneous status information.

Required privilege

This utility requires no privileges.

Syntax

ttStatus {-h | -help | -?}
ttStatus {-V | -version}
ttStatus [-v] [-r secs] [-[no]pretty]

Options

ttStatus has the options:

Option	Description
`-h` `-help` `-?`	Prints a usage message and exits.
`-[no]pretty`	Do [not] use pretty formatting. The default is pretty formatting, which uses the values of the ConnectionName attribute.
`-r` `secs`	Allows ttStatus to continue running. Updates status report every secs seconds.
`-V \| -version`	Prints the release number of ttStatus and exits.
`-v`	Prints detailed information that is useful for TimesTen customer support.

Sample output

When you invoke the command, a report that describes the current state of the system is displayed to stdout. The following is sample output:

TimesTen
 status report as of Thu Jul 17 19:15:41 2008Daemon pid 26622 port 4133 instance sadrakeNo TimesTen server running------------------------------------------------------------------------Data store /scratch/timesten_user/rdbmsThere are 7 connections to the data storeData store is in shared modeShared Memory KEY 0x13014429 ID 80347138PL/SQL Memory KEY 0x14014429 ID 80379907 Address 0x2345678900000000Type            PID     Context     Connection Name              ConnIDProcess         26743   0x08117148  rdbms                             1Subdaemon       26626   0x080bdfa8  Worker                         2042Subdaemon       26626   0x08159228  Flusher                        2043Subdaemon       26626   0x081c8850  Monitor                        2044Subdaemon       26626   0x08217c10  HistGC                         2045Subdaemon       26626   0x08266fd0  Aging                          2046Subdaemon       26626   0x082b6390  Checkpoint                     2047Replication policy  : ManualCache agent policy  : ManualAccess control enabled.PL/SQL enabled.End of report

When you invoke the command with the -pretty option, a report that describes the current state of the system is displayed to stdout. The following is sample output:

Data store /ds0/timesten_user/sample
          There are 7 connections to the data store
          Data store is in shared mode
          Shared Memory KEY 0x13014429 ID 80347138
          PL/SQL Memory KEY 0x14014429 ID 80379907 Address 0x2345678900000000
      Type            PID     Context             Connection Name      ConnID
Process        29508   0x00000001001c6680  rdbms                     1
Process         26743   0x08117148  rdbms                             1Subdaemon       26626   0x080bdfa8  Worker                         2042Subdaemon       26626   0x08159228  Flusher                        2043Subdaemon       26626   0x081c8850  Monitor                        2044Subdaemon       26626   0x08217c10  HistGC                         2045Subdaemon       26626   0x08266fd0  Aging                          2046
Subdaemon       26626   0x082b6390  Checkpoint                     2047
          Replication policy  : Manual
          Cache agent policy : Manual
          Access control enabled.
          PL/SQL enabled.

Notes

While primarily intended for use by TimesTen customer support, this information may be useful to system administrators and developers.

This utility is supported only where the TimesTen Data Manager is installed.