Sorry if I've missed a definitive answer to this question, but I'm looking for the absolute maximum amount of data that can be stored in a single BDB JE 5.0.x database. Based on EnvironmentConfig.LOG_FILE_MAX of 1Gb for a standard JVM and a maximum log file name of ffffffff.jdb, I calculate that the absolute maximum environment size is about 2.5 Zb. Is that correct? If that is correct, is it possible for a single database to use all of the available environment space? In other words, is it possible for a single database to be 2.5 Zb? Thx.
Edited by: user4399464 on Sep 10, 2012 10:56 AM
The number I get when multiplying 1 GB by 0xFFFFFFFF is: 4,611,686,017,353,646,080. This is maximum size of the log. However, we've never had a disk large enough in-house to create a log this large.
Also note that the max log size is not the same as the max data size (record data). Each record has overhead -- metadata. In addition, by default the log is only 50% utilized -- see http://docs.oracle.com/cd/E17277_02/html/GettingStartedGuide/logfilesrevealed.html.
Also, once log size exceeds RAM by a certain multiple, cleaning stops progressing, and the amount of wasted space begins to grow forever. So in practice RAM is the limiting factor for a functioning DB.