When large page size is not desirable On a system with limited memory or limited disk space, large database pages may not improve performance.

Large database pages reduce I/O time because can access more data with fewer I/Os. However, large pages require more memory. allocates a bulk number of database pages in its page cache by default. If the page size is large, the system might run out of memory.

Use the -Xmx flag as an optional parameter to the JVM to give the JVM more memory upon startup.

For example:

java -Xmx64M myApp

If you have limited disk space and cannot afford the overhead of the minimum two pages per table, keep your page sizes small.