Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Berkeley DB Family
Berkeley DB High Availability (Replication)
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Dec 8, 2011 9:34 AM by
Calculating the size of the database in memory
Dec 5, 2011 4:36 AM
I am using BDB 5.1.19 with BTREE as an access method.
I would like to calculate the memory footprint that would be needed for that.
I followed the following doc:
useful-bytes-per-page = (page-size - page-overhead) * page-fill-factor
bytes-of-data = n-records *
(bytes-per-entry + page-overhead-for-two-entries)
n-pages-of-data = bytes-of-data / useful-bytes-per-page
total-bytes-on-disk = n-pages-of-data * page-size
I am not interested in calculating the size on disk but just in memory.
Would the following be enough:
bytes-of-data = n-records *(bytes-per-entry + page-overhead-for-two-entries)
Since the rest is only for space on disk i don't need it, is that correct?
Would this calculation help me also to calculate the cache size or is the cache size influenced by the page size?
This content has been marked as final.
Show 1 reply
Re: Calculating the size of the database in memory
Dec 8, 2011 9:34 AM
in response to
This is not a replication question and those of us monitoring this forum are not the best people to answer this question. You'll probably get a better and faster answer if you post it to the general Berkeley DB forum: