Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Mohammad.

Asked: April 10, 2016 - 10:14 am UTC

Last updated: April 11, 2016 - 3:46 am UTC

Version: Times Ten In-Memory Dataase 11.2.2(64-bit) / Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

Viewed 1000+ times

You Asked

Hi All,

Hope you are doing fine.

I have a question regarding Times Ten In-Memory Database 11.2.2. Can we connect it with ORACLE Database 12c?

I tried with that, and i installed and configured all desired setups as mentioned in ORACLE documents and videos. But, with no luck, the queries i have still take the same time as before using Times Ten.

Could you please send to me the required steps to Install and Configure Times Ten on "Windows Server 2012R2", and how to call SQL queries to get high performance in Micro seconds as ORACLE mentioned in it's Documents / White paper.

And there are any restrictions or special circumstances to achieve Times Ten benefits, and may be it will not work with small tables or with simple queries?

I ran a set of queries (around 50) and they read from small tables (max retrieved records are 15KB), all queries take around 1.2 sec, and the target is n msec.

Please advise regarding that, and what the best solution to apply with reference to return to it and get configurations.


Thank you so much.


and Connor said...

Installation guide is here:

https://docs.oracle.com/cd/E21901_01/timesten.1122/e21632/install.htm#TTINS113

But TimesTen performance is similar to any performance related activity - you need to know *where* the time is being spent.

If Times Ten is returning data in 1millsecond, and it takes 800millseconds to get it across the network to you client, then you dont have a TimesTen issue.

So I would start with some simple benchmarks, eg

- query response time for small resultset on same node as TimesTen db (should be near RAM-speed).

- then query response time for larger or more complex query on same node as TimesTen db

- then across network link

etc etc etc..

Find the *source* of the delay. If you can then prove its TimesTen, you've now got a good test case to provide to Support.

Hope this helps.

Rating

  (1 rating)

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

Comments

More Details ....

Mohammad Awadallah, April 11, 2016 - 5:21 am UTC

Hi Mr.Connor,

Thank you for reply.

Excuse me to show you more details regarding my case, sorry for lack of explanation in first question; the case that I have:

I am working locally on Database server with good specs. as RAM and H.D.

I installed Times Ten on the same server, and then I create a user with the desired privileges on Times Ten, and start execute my queries.

I have 52 queries that take ~1.2 sec when executing on Database server, and after run the same queries on the same Database server (Locally, with no need for network) i got the same elapsed time ~1.2 sec.

So, my question is, how can i get milliseconds for execution of those queries, on the other hand, how can I achieve Times Ten feature and benefits?

I followed up all desired setup and commands, But, with no luck.

Can you please mention a practical example on how to use Times Ten on local server or between server and client, and without using it with showing elapsed time differences?

And is Times Ten useful just when we are talking about Application tier / Client side, and no need for local using on the same Database server?

Thank you so much.


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 channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.