Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Santhosh.

Asked: March 21, 2017 - 6:33 am UTC

Last updated: August 08, 2022 - 1:35 am UTC

Version: 11G

Viewed 1000+ times

You Asked

Hi,
Please answer my below questions
1.What is Time ten SQL?
2.whats the difference between Time Ten SQL and Pl/SQL?

and Connor said...

Times Ten is an memory-based database that runs in the *application tier* if you need incredibly fast caching at the application tier level.

http://www.oracle.com/technetwork/database/database-technologies/timesten/overview/index.html

PL/SQL is a language used to have 3GL style logic in programs running *inside* the database server. It does not really have any relationship to Times Ten

http://www.oracle.com/technetwork/database/features/plsql/index.html

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Difference between timesten in memory and in very large SGA

Asim, August 07, 2022 - 1:56 pm UTC

Suppose my total size of database is 4gb, and I have a 64gb RAM in my computer, now I set SGA= 16gb.

As SGA is 4 times the dadabase size oracle may and will store all database in SGA

So how will the above differ from timesten in memory ? Arent both the same now?

Connor McDonald
August 08, 2022 - 1:35 am UTC

Not really. There's a number of differences because TimesTen "knows" that it only is a in-memoory database.

Take a look here at the architecture

https://docs.oracle.com/cd/E11882_01/timesten.112/e21631/arch.htm#TTCIN156

in particular, how we can cache related tables together, and also that we can link apps to have direct access to the shared memory of a timesten database as opposed to always having to talk a separate process to do the data access.

Its because of this bespoke nature, you can insane in-mem performance levels out of timesten (ie, tens of millions of transactions per second)

This is not to say that using all the memory for your conventional database wont also improve things - it will.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.