1 Reply Latest reply on Jul 13, 2012 4:41 PM by ChrisJenkins-Oracle

    TimesTen on the Database Host

      I have reviewed the documentation and usually see Oracle 11g TimesTen (IMDB) Cache as part of the "Middle Tier".
      Can Oracle 11g TimesTen (IMDB) Cache and the Oracle 11g Database be installed on the same host?

      I have extra real memory on the host that runs the Oracle 11g Database and want to take advantage on IMDB Cache.
      What is the reasoning behind running IMDB Cache on the "Middle Tier".
        • 1. Re: TimesTen on the Database Host
          It is technically possible to install and run TimesTen on the same host as oracle Db but this is not a recommended configuration because:

          1. Unless the Oracle/TT server has adequate hardware (CPU/Memory/Storage) and has been very carefully setup you are likely to get competition for memory, CPU and disk I/O resources between TimesTen and Oracle DB which will nnegatively impact the performance of both.

          2. TimesTen delivers best performance when it is co-located with the application logic that is accessing it. When the application and TimesTen are on the same machine the appplication can use 'direct connection' mode which eliminates all IPC (even local IPC) from the app <-> TimesTen communication resulting in very efficient and low latncy communication between the app and TimesTen. When TimesTen is on the same server as oracle all interactions with TimesTen still incur a network roundtrip which is very expensive compared to typical SQL execution times in TimesTen.

          So yes you can do it but in most cases it is a bad idea and won't deliver anything like the benefits you would getif you put TimesTen in the middle tier.

          1 person found this helpful