This discussion is archived
1 Reply Latest reply: Jul 11, 2012 12:26 AM by Gennady Sigalaev RSS

Limitation of Oracle Timesten Database

hitgon Expert
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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

Legend

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