This discussion is archived
4 Replies Latest reply: Sep 4, 2013 10:11 AM by Tim Vincent RSS

Timesten permsize is triple oracle's tablespace file

user2545677 Newbie
Currently Being Moderated

(1)  I create a oracle 11g2 instance,  and  a user  dev   and its tablespace

dev's tablespace size: 576,724,992      (about 476,800  records in main tables)

 

(2)  then create a timesten instance to cache dev's tables

timesten  data store file size:   1783951360 

timesten  perm memory size:   1723348 KB     (PERM_IN_USE_SIZE of  sys.monitor ):

 

 

two question:

(1)  why on earth timesten triple the data size for  the very same data

(2)  how can I evaluate timesten perm size for the very same data from oracle, simply triple?

Legend

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