Timesten - Connection

Timesten Component

About

An application can connect to the IMDB Cache or TimesTen database by:

connections.

You may see up to 2047 connections.

While the best response time is achieved with TimesTen running in-process with the application (also known as “direct mode”), conventional client/server access is commonly used when a database is shared by several applications running on different servers.

Applications access TimesTen databases using standard SQL via:

  • JDBC,
  • ODBC,
  • ODP.NET,
  • OCI (Oracle Call Interface),
  • Pro*C/C++,
  • and Oracle PL/SQL programming interfaces.

The routines that implement the TimesTen functionality are embodied in a set of shared libraries that developers link with their applications and execute as a part of the application's process.

Sqldeveloper Connection Timesten

How to

see all current connections

ttxactadmin

with the ttxactadmin

[oracle@Exalytics-01 ~]$ ttxactadmin -connections DI_TT_AGGR_STORE;
2012-06-22 13:58:28.393
/u01/app/oracle/product/aggregate_store/tt_aggr_store/di_tt_aggr_store
TimesTen Release 11.2.2.2.0

ID   PID     Context            Name             Program        State TransID     UID

   1 2144    0x0000000000e926c0 di_tt_aggr_store ttIsqlCmd      Run               ORACLE
   2 2387    0x000000000167a880 nqsserver        ttcserver      Run      2.0      DI_OBIEE_AIRLINE_AGG
1930 30384   0x0000000000c2e0e0 AsyncMV          timestensubd   Run               SYS
1931 30384   0x0000000000bd9cd0 Deadlock Detector timestensubd  Run               SYS
1932 30384   0x00007fa894040c40 HistGC           timestensubd   Run               SYS
1933 30384   0x00007fa88c0008e0 Aging            timestensubd   Run               SYS
1934 30384   0x00007fa894055010 IndexGC          timestensubd   Run               SYS
1935 30384   0x0000000000bb1530 Checkpoint       timestensubd   Run               SYS
1936 30384   0x0000000000bc5900 Monitor          timestensubd   Run               SYS
1937 30384   0x0000000000b9d040 Log Marker       timestensubd   Run               SYS
1938 30384   0x0000000000b88c70 Flusher          timestensubd   Run               SYS
1939 30384   0x0000000000aa4a70 Rollback         timestensubd   Run               SYS
1940 30384   0x0000000000a4e430 Manager          timestensubd   Run               SYS
11 connections found

where the program:

ttstatus

With ttstatus

[oracle@Exalytics-01 ~]$ ttstatus
TimesTen status report as of Fri Jun 22 14:07:33 2012

Daemon pid 30380 port 53396 instance tt1122
TimesTen server pid 2379 started on port 53397
------------------------------------------------------------------------
Data store /u01/app/oracle/product/aggregate_store/tt_aggr_store/di_tt_aggr_store
There are 13 connections to the data store
Shared Memory KEY 0x5f11c0df ID 996376578 (LOCKED)
PL/SQL Memory KEY 0x6011c0df ID 996409350 Address 0x7fa0000000
Type            PID     Context             Connection Name              ConnID
Process         2144    0x0000000000e926c0  di_tt_aggr_store                  1
Server          2387    0x000000000167a880  nqsserver                         2
    (Client Information: pid: 24436; IPC: TCP/IP;
        Node: Exalytics-01 (192.168.0.194))
Subdaemon       30384   0x0000000000a4e430  Manager                        1940
Subdaemon       30384   0x0000000000aa4a70  Rollback                       1939
Subdaemon       30384   0x0000000000b88c70  Flusher                        1938
Subdaemon       30384   0x0000000000b9d040  Log Marker                     1937
Subdaemon       30384   0x0000000000bb1530  Checkpoint                     1935
Subdaemon       30384   0x0000000000bc5900  Monitor                        1936
Subdaemon       30384   0x0000000000bd9cd0  Deadlock Detector              1931
Subdaemon       30384   0x0000000000c2e0e0  AsyncMV                        1930
Subdaemon       30384   0x00007fa88c0008e0  Aging                          1933
Subdaemon       30384   0x00007fa894040c40  HistGC                         1932
Subdaemon       30384   0x00007fa894055010  IndexGC                        1934
RAM residence policy: Manual
Data store is manually loaded into RAM
Replication policy  : Manual
Cache Agent policy  : Manual
PL/SQL enabled.
------------------------------------------------------------------------
Accessible by group oinstall
End of report





Discover More
Timesten Component
(TimesTen|TT) (In-Memory Database|IMDB)

Oracle TimesTen In-Memory Database (TimesTen) is amemory-optimized relational database. IMDB = In-Memory Database For existing application with data residing on the Oracle Database, TimesTen is deployed...
Jedit Search Replace With Return Value
JEdit - Search and Replace

example The goal is here to add quotes and to have the text in lower-case. Search for: Replace with: where: _0 is the java text object to be replaced Result: Input file: Search for:...
Timesten Component
Timesten - (SQL Developer|ODBC Client) Configuration

How to configure SQL Developer to connect to a Timesten Database. Download and install the last version of SQL Developer downloadSQL Developer To access a TimesTen database from SQL Developer,...
Timesten Component
Timesten - (Server) Process

A server process manages a connection. See the ttstatus utility By default, a server process is spawned at the time a client requests a connection. By setting the -serverPool option in the...
Timesten Component
Timesten - Character Set

When the connection character set and the database character set are different, data conversion is performed in the ODBC layer. The default connection character set is US7ASCII. This setting applies...
Timesten Client And Timesten Server
Timesten - Client/Server Connection

The client application refers to the Client DSN when initiating a connection to locate and connect to the TimesTen database. The Client DSN defines: the server machine and the Server DSN. The...
Timesten Component
Timesten - Connection Attribute

The connection attributes are of two types: first : to specify how the TimesTen database is loaded and configured, general: to specify how the connections are to be controlled or managed. instance...
Timesten Component
Timesten - DSN

When you connect from an application, you use a Data Source Name (DSN) to uniquely identify the particular TimesTen database to which you want to connect. A DSN is a character-string name that identifies...
Timesten Component
Timesten - Data Import

You can send data to a Timesten database: with an Driver Connection and an application (script or ELT, ETL tool) by using the cache function or by using the Timesten ttbulkcp utility
Timesten Component
Timesten - Database Installation and configuration on Linux

On UNIX/Linux systems before installing application, you must in general configure the following: The number of semaphores Allowable shared memory In addition for timesten, you need to perform the...



Share this page:
Follow us:
Task Runner