. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 506 MON$MEMORY_USAGE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . that the memory allocated for storing the return value will be freed after the function is executed. It is used only if the memory was allocated dynamically in the UDF. In such a UDF, the memory must be functions used in Firebird code and in the code of the shipped UDF modules, for allocating and freeing memory. ENTRY_POINT clause specifies the name of the entry point (the name of the imported function),

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 757 MON$MEMORY_USAGE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . wasted space of a 3KB blob on page size 4096 with one on 32768: +/- 1KB vs +/- 29KB), and increase memory consumption of the page cache. LENGTH Clause specifying the maximum size of the primary or secondary means that the memory allocated for storing the return value will be freed after the function is Chapter 5. Data Definition (DDL) Statements 211 executed. It is used only if the memory was allocated

-219 335544395 relnotdef Table is not defined -239 335544691 cache_too_small Insufficient memory to allocate page buffer cache -260 335544690 cache_redef Cache redefined -281 335544637 no_stream_plan lignment Datatype misalignment. The attempted to read or write a value that was not stored on a memory boundary. -901 335544770 exception_array_bounds_exceeded Array bounds exceeded. The code attempted requirements of the runtime stack have exceeded the memory available to it. -901 335544782 exception_sigsegv Segmentation Fault. The code attempted to access memory without priviledges. -901 335544783 exception_sigill

logb_small Log block too small at offset %ld in log file %s -239 335544691 cache_too_small Insufficient memory to allocate page buffer cache -239 335544693 log_too_small Log size too small -239 335544694 partition_too_small -901 336723998 gsec_op_specified Operation already specified -901 336920607 gstat_sysmemex System memory exhausted -901 336330783 gbak_db_info_failed gds_$database_info failed -901 336723999 gsec_pw_specified Firebird 2.0 Error Codes SQLCODE GDSCODE SYMBOL TEXT -901 335740993 gfix_mem_exhausted Virtual memory exhausted -901 336330818 gbak_open_error Cannot open status and error output file %s -901 335740994

logb_small Log block too small at offset @1 in log file @2 -239 335544691 cache_too_small Insufficient memory to allocate page buffer cache -239 335544693 log_too_small Log size too small -239 335544694 partition_too_small -901 336723998 gsec_op_specified Operation already specified -901 336920607 gstat_sysmemex System memory exhausted -901 336330783 gbak_db_info_failed gds_$database_info failed -901 336723999 gsec_pw_specified maximum size -901 335740992 gfix_corrupt_pool Corrupt pool -901 335740993 gfix_mem_exhausted Virtual memory exhausted -901 336330817 gbak_open_bkup_error Cannot open backup file @1 -901 335740994 gfix_bad_pool

........................................................................................ 696 MON$MEMORY_USAGE .......................................................................................... Класс ошибок HY (условия CLI- specific) HY000 CLI-specific condition Условия CLI-specific HY001 Memory allocation error Ошибка выделения памяти HY003 Invalid data type in application descriptor установлен сейчас HY012 Invalid transaction operation code Неверный код транзакции операции HY013 Memory management error Ошибка управления памятью HY014 Limit on the number of handles exceeded Достигнут

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 681 MON$MEMORY_USAGE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54023 Too many arguments SQLCLASS HY (CLI-specific Condition) HY000 CLI-specific condition HY001 Memory allocation error HY003 Invalid data type in application descriptor HY004 Invalid data type HY007 sequence error HY011 Attribute cannot be set now HY012 Invalid transaction operation code HY013 Memory management error HY014 Limit on the number of handles exceeded HY015 No cursor name available

allocated to store (cache) database pages in memory to help improve the efficiency of the database performance. It is far quicker to read data from memory that it is to have to physically read the data Database Write Mode Many operating systems employ a disk cache mechanism. This uses an area of memory (which may be part of your server’s overall RAM or may be built into the disk hardware) to buffer

51 COUNT ===================== 42 Current memory = 19570960 Delta memory = 0 Max memory = 19652528 Elapsed time = 0.001 sec Buffers = 2048 Reads = 0 Writes = 0 Fetches

10 Table of Contents 1 Chapter 1. Introduction Firebird uses a page cache to hold pages in memory. It is much quicker to retrieve pages from RAM than to go out onto the disc system and read them Support mailing list. The posting was in response to a query asking if there is a way to reduce the memory cache without giving up too much performance? This was itself in respect of a system that was taking