1 Reply Latest reply: Jul 11, 2012 2:26 AM by Gennady Sigalaev RSS

    Limitation of Oracle Timesten Database

    hitgon
      Hi,

      We want to deploy the Oracle Timesten11.2 on 64bit RHEL Platform.

      Total Physical RAM Size in Server is 32 GB.

      There are 40 Millions rows in single subscriber table(45 Columns) in Oracle Database
      We want to configure the READ-ONLY-LOCAL CACHE in Oracle Timesten for this subscriber table.

      What should be the size of Oracle Timesten Database for support the above configuration.

      Regards
      Hitgon
        • 1. Re: Limitation of Oracle Timesten Database
          Gennady Sigalaev
          Hi hitgon,

          You can use the ttSize utility (http://docs.oracle.com/cd/E21901_01/doc/timesten.1122/e21643/util.htm#CHDEHFIE) for prediction the size.

          Example: ttSize -tbl tableName -rows 40000000 your_DSN

          Additionally, you can use ttComputeTabSizes function and tablesize clause for getting the actual table size
          Command> call ttComputeTabSizes('emp');
          Command> tablesize emp;
          
          Sizes of GENA.EMP:
          
            INLINE_ALLOC_BYTES:   0
            NUM_USED_ROWS:        0
            NUM_FREE_ROWS:        0
            AVG_ROW_LEN:          Not computed
            OUT_OF_LINE_BYTES:    0
            METADATA_BYTES:       784
            TOTAL_BYTES:          784
            LAST_UPDATED:         2012-01-19 19:37:07.000000
          
          1 table found.
          Command>
          Command> insert into emp values (1,sysdate,'gena', 'gena', 'gena', 1);
          1 row inserted.
          Command> call ttComputeTabSizes('emp');
          Command> tablesize emp;
          
          Sizes of GENA.EMP:
          
            INLINE_ALLOC_BYTES:   52080
            NUM_USED_ROWS:        1
            NUM_FREE_ROWS:        255
            AVG_ROW_LEN:          206
            OUT_OF_LINE_BYTES:    0
            METADATA_BYTES:       784
            TOTAL_BYTES:          52864
            LAST_UPDATED:         2012-01-19 19:37:54.000000
          
          1 table found.
          Command>
          Regards,
          Gennady