Stack Overflow
Stack Overflow

Questions tagged [timesten]

TimesTen is a high performance event-processing software component that enables applications to capture, store, use, and distribute information in real-time, while preserving transactional integrity and continuous availability.

TimesTen is designed to operate most efficiently in an application’s address space. Using standard interfaces, TimesTen can be integrated into an application to serve as either a stand-alone relational database management system (RDBMS) or an application-tier cache that works in conjunction with a traditional disk-based RDBMS, such as the Oracle database. TimesTen can be configured to operate entirely in memory, or it can be configured for disk-based environments to log and checkpoint data to disk.

TimesTen is available in a specially-licensed edition, TimesTen for Exalytics, to support Oracle's Exalytics BI Machine. This version of TimesTen makes available various analytic functions, as well as columnar compression. These features are not available in standard TimesTen.

75 questions
0
votes
2 answers

Is Oracle's TimesTen & Oracle NoSQL the same product?

Is Oracle's TimeTen in-memory database the same product as it's new Oracle NoSQL product offering? UPDATE: The genesis for this post is the following, when someone wrote: "I don’t expect Oracle NoSQL database to be a new product. Just a rebranding…
nickb
  • 9,140
  • 11
  • 39
  • 48
0
votes
0 answers

DataGrip (Idea DB plugin) extremely slow fetching

I am using IntelliJ Idea Database plugin (DataGrip) to query TimesTen database, but the fetching of the data takes extremely long. -- 2023-05-23 13:39:09 [DB] [TimesTen] [console: console [TimesTen]] [session id: 1160215063] [statement id:…
Jakub Znamenáček
  • 766
  • 1
  • 4
  • 18
0
votes
1 answer

sql developer connect to Timesten database

When I try to connect to the timesten databse using the SQL developer, I am getting following error message. Unrecognized JDBC URL subtype: TimesTen I kept the classes13.jar in system classpath and also included in the Tools - > preferences ->…
rahul
  • 1
  • 5
0
votes
1 answer

How to get full outer join in TimesTen

How do I get full outer join in TimesTen DB? I tried this: select t1.column1, t2.column2 from table1 t1 full outer join table2 t2 on t1.column1 = t2.column2; This works in Oracle but when I run it against TimesTen it throws an error, that there…
Jakub Znamenáček
  • 766
  • 1
  • 4
  • 18
0
votes
2 answers

TimesTen difference between two timestamps

I would like to get difference between two columns (both TT_TIMESTAMP(26,6)) select timestamp1 - timestamp2 as diff from table; but getting this error: An interval data type must be specified for a datetime arithmetic result Any ideas?
Jakub Znamenáček
  • 766
  • 1
  • 4
  • 18
0
votes
2 answers

How do I select row with maximum value of some column

Hi this seems like very easy task but I could not find answer for it. I would like to get only one row from table where some specific column has maximum value. So, for example if I have this table: ╔═══════╦═════╦═══════╗ ║ Name ║ Age ║ Color…
Jakub Znamenáček
  • 766
  • 1
  • 4
  • 18
0
votes
0 answers

Running a TimesTen query from a Python script works fine. When I put it in my crontab, it doesn't work as expected

I have a python script which queries a TimesTen database and stores the output in a file, and emails it off. When I run it from its directory /home/directory/script.py, it works absolutely fine and pulls the data from the TimesTen db to a text file…
knight
  • 39
  • 5
0
votes
1 answer

How do I decide where I should locate my TimesTen database files?

I am setting up a TimesTen In-Memory database and I am looking for guidance on the storage and location that I should use for the database's persistence files.
Chris J
  • 81
  • 5
0
votes
1 answer

Is it okay if I store database files and other user created files within a TimesTen instance tree?

I am setting up a TimesTen in-memory database installation and I am wondering if it is okay to store the actual database files, and maybe some other user created files, within the directory tree of the actual TimesTen instance (as it would be…
Chris J
  • 81
  • 5
0
votes
1 answer

Should I use huge pages for my TimesTen database, and if so how do I configure that?

I've heard that it is recommended to use huge pages for the memory used by a TimesTen database. Is that correct? If so how do I configure the OS and TimesTen to ensure that it uses huge pages?
Chris J
  • 81
  • 5
0
votes
1 answer

How to size memory required for TimesTen In-memory Database?

How do I figure out the right values for the memory parameters in TimesTen? How much memory do I need based on my tables and data?
Chris J
  • 81
  • 5
0
votes
1 answer

Installation and Configuration

Oracle TimesTen direct connectivity mode is the preferred mode of connection for the lowest possible latency. How can I connect using that and are there any limitations?
Shailendra Mishra
  • 1
0
votes
1 answer

Oracle TimesTen Installation and Configuration

How do I set up the environment so I can connect to TimesTen, use utilities, etc?
Shailendra Mishra
  • 1
0
votes
1 answer

Oracle timestein issue (Log Marker) waiting for latch "Log Strand Insertion

I am getting below error while using multiple DS under timetein ConnId=137 (Log Marker) waiting for latch "Log Strand Insertion[0]"(12345), Holder=1 (c_node) PID 1, now 10 secs ConnId=135 (Log Marker) waiting for latch "Log Strand…
grv
  • 33
  • 4
0
votes
2 answers

Calling userdefined PLSQL functions in TimesTen database query

How to call PLSQL functions inside the query of TimesTen database. When I am calling, it is giving such error 2818: Unknown function GET_COSTPRICE. If this is a PLSQL function note that such functions are not yet supported in SQL statements. The…
Dyapa Srikanth
  • 1,231
  • 2
  • 22
  • 60
1 2
3
4 5