2 Replies Latest reply on Mar 6, 2018 10:38 AM by Gasimov Hafiz

    What is *USE_HIGH_WATER in InMemory DB ?

    Gasimov Hafiz

      Hi everyone.

      My timesten datastore size as below.

      Command> dssize

      The following values are in KB:

        PERM_ALLOCATED_SIZE:      35840000

        PERM_IN_USE_SIZE:         12543391

      PERM_IN_USE_HIGH_WATER:   35829722

        TEMP_ALLOCATED_SIZE:      4194304

        TEMP_IN_USE_SIZE:         230417

        TEMP_IN_USE_HIGH_WATER:   1143590

      Command>

       

      how do i reduce it PERM_IN_USE_HIGH_WATER and TEMP_IN_USE_HIGH_WATER?

      what is PERM_IN_USE_HIGH_WATER and TEMP_IN_USE_HIGH_WATER?

       

      Thanks.

        • 1. Re: What is *USE_HIGH_WATER in InMemory DB ?
          Gaz in Oz

          "dssize" is used to report the current memory status of the permanent and temporary partitions and the maximum, allocated and in-use sizes for the database.

          Command> dssize
          The following values are in KB:
          
            PERM_ALLOCATED_SIZE:      40960
            PERM_IN_USE_SIZE:         11043
            PERM_IN_USE_HIGH_WATER:   11043
            TEMP_ALLOCATED_SIZE:      32768
            TEMP_IN_USE_SIZE:         9446
            TEMP_IN_USE_HIGH_WATER:   9509
          
          Command>
          

          Line 06. shows the highest usage of Permsize memory.

          Line 05. shows the current allocation.

          Line 04. shows the actual allocated size.

          The same for the TEMP_* parameters.

          The values are available/gotten from the table sys.monitor.

           

          You do not need to reduce *_IN_USE_HIGH_WATER values as they are for information only, showing the max used memory for Tempsize and Permsize memory, as used by using the db.

          To reset the stats, bounce the database and view the output of dssize BEFORE the database does any work and the high water stats will be lower in all likelyhood.

           

          Take a look at Permsize and Tempsize as described in the manual.

          https://docs.oracle.com/cd/E11882_01/timesten.112/e21643/attribute.htm#TTREF11

          1 person found this helpful
          • 2. Re: What is *USE_HIGH_WATER in InMemory DB ?
            Gasimov Hafiz

            Thanks for answer.