This discussion is archived
5 Replies Latest reply: Aug 21, 2012 1:12 AM by 598001 RSS

Get how much memory does timesten use.

948372 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    On Linux you can also minitor memory used by TimesTen using
    ipcs -m
    command
  • 4. Re: Get how much memory does timesten use.
    ChrisJenkins Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    You are right.
    We use this method to monitor memory on host. We create charts wat include all sorts of used memory.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points