> I am running SS FB 3.0.4 x64 in Windows 10 x64 with 16GB RAM.
>
> Database properties
> ================
> ODS Version 12
> Page size 16384
> Pages 437728
> Size on disk 6.68GB
> Page buffers 10240
> Read only false
>
> Settings
> ========
> Dialect 3
> Default character set NONE
> Sweep interval 20000
> Forced writes
>
> Database alias in databases.conf file
> =============================
> my_dba = C:\Dba\my_dba.fdb
> {
>     FileSystemCacheThreshold = 2M
>     LockMemSize = 16M
>     LockHashSlots = 30011
>     TempCacheLimit = 2048M
>     TempBlockSize = 2M
>     DefaultDbCachePages = 65536
> }
>
> I ran a query with flamerobin, this is the statistic result :
> =========================================
> 46220441 fetches, 17965 marks, 172471 reads, 82 writes.
> 8847 inserts, 0 updates, 0 deletes, 15730299 index, 8847 seq.
> Delta memory: 4206064 bytes.
> G_TMP: 8847 inserts.
> Total execution time: 52.434s
> Script execution finished.
>
> On Windows Task Manager, Firebird Server took 236MB RAM, max.
>
> If not mistaken, Page Cache Size should be
> Page Size x DefaultDbCachePages = 16384 x 65536 = ~ 1GB
>
> Why Firebird server only took 236 MB RAM ? Is this normal or something
> missed here ?

DefaultDbCachePages (65536 in your case) is only used if Page buffers at
database level is set to 0. Yours is set to 10240.

Hope this helps.

--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.