5 Replies Latest reply: Aug 21, 2012 3:12 AM by 598001 RSS

    Get how much memory does timesten use.

    948372
      Hi Chris,

      I want to check how much memory does timesten use, I run this SQL in ttisql:

      select sysdate, PERM_ALLOCATED_SIZE, PERM_IN_USE_SIZE, PERM_IN_USE_HIGH_WATER, TEMP_ALLOCATED_SIZE, TEMP_IN_USE_SIZE, TEMP_IN_USE_HIGH_WATER from sys.monitor;

      and it prints:

      < 2012-08-08 01:47:46, 8192000, 97801, 97842, 5120000, 82484, 540572 >


      Does it mean:
      The total memory TimesTen instance can use is: 8192000 (8G);
      There are 97801 (97MB) used for storing data, in other words, the data in my cache group takes up 97 MB in total.
      Right?

      And also may I know what the TEMP_ALLOCATED_SIZE (the tempsize in sys.odbc.ini) means?

      Thanks a lot!
        • 1. Re: Get how much memory does timesten use.
          Gennady Sigalaev
          Hi 945369,

          Documentation (http://docs.oracle.com/cd/E21901_01/doc/timesten.1122/e21633/using.htm#BCGHAIBG) says:

          "Oracle TimesTen manages database space using two separate memory partitions within a single contiguous memory space. One partition contains permanent data and the other contains temporary data.
          - Permanent data includes the tables and indexes that make up a TimesTen database. When a database is loaded into memory, the contents of the permanent data partition are read from files stored on disk. The permanent data partition is written to disk during checkpoint operations.
          - Temporary data includes locks, cursors, compiled commands, and other structures needed for command execution and query evaluation. The temporary data partition is created when a database is loaded into memory and is destroyed when it is unloaded.
          The connection attributes that control the size of the database when it is in memory are PermSize and TempSize. The PermSize attribute specifies the size of the permanent data partition and the TempSize attribute specifies the size of the temporary data partition."

          Additionally you can use the following command for getting the db size:
          Command> dssize;
          
            PERM_ALLOCATED_SIZE:      32768
            PERM_IN_USE_SIZE:         5867
            PERM_IN_USE_HIGH_WATER:   5867
            TEMP_ALLOCATED_SIZE:      32768
            TEMP_IN_USE_SIZE:         6789
            TEMP_IN_USE_HIGH_WATER:   7351
          
          Command>
          regards,
          Gennady
          • 2. Re: Get how much memory does timesten use.
            948372
            Hi Gennady,

            Thank you very much for your answer, it is very clear!


            Best Regards,
            Wenbin
            • 3. Re: Get how much memory does timesten use.
              598001
              On Linux you can also minitor memory used by TimesTen using
              ipcs -m
              command
              • 4. Re: Get how much memory does timesten use.
                Chrisjenkins-Oracle
                Note that ipcs -m only tells you how large a shared memory segment TimesTen has allocated from the O/S and you can anyway know this as it is just PermSize+TempSize+LogBufMB+~20MB. It does not give you any insight into how much of that memory is actually used within TimesTen.

                Chris
                • 5. Re: Get how much memory does timesten use.
                  598001
                  You are right.
                  We use this method to monitor memory on host. We create charts wat include all sorts of used memory.