. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 3. Using MON$IO_STATS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . out as required - but the cache will always be full. You can use the MON$ tables (in Firebird 2.1 onwards, especially MON$IO_STATS) to figure out how well your cache is being used. They will report on from disk. When the number of reads goes up dramatically, you’ve reduced the cache too much. The MON$ tables will also give you the number of Marks vs. Writes, which tells you the number of times pages

. . . 501 MON$ATTACHMENTS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 502 Using MON$ATTACHMENTS to . . . . 503 MON$CALL_STACK . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 503 MON$CONTEXT_VARIABLES . . . 505 MON$DATABASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 505 MON$IO_STATS . . . . . . .

it’s not really all that secure as the following SQL command shows: SQL> select MON$DATABASE_NAME from mon$database; MON$DATABASE_NAME ================================= /data/databases/firebird/test.fdb and later no longer has system functions as such), collations and roles. SQL> show system; Tables: MON$ATTACHMENTS ... SEC$USER_ATTRIBUTES Collations: ASCII ... WIN_PTBR Roles: RDB$ADMIN The show system command. SQL> show table mon$io_stats; MON$STAT_ID (RDB$STAT_ID) INTEGER Nullable MON$STAT_GROUP (RDB$STAT_GROUP) SMALLINT Nullable MON$PAGE_READS

. . . 750 MON$ATTACHMENTS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 751 Using MON$ATTACHMENTS to . . . . 753 MON$CALL_STACK . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 753 MON$CONTEXT_VARIABLES . . . 754 MON$DATABASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 755 MON$IO_STATS . . . . . . .

are created; • The header page is formatted and written; • The various system tables — RDB$ and MON$ — and associated indices are created, and appropriate pages formatted and written to disc; • Every table — MON$DATABASE which has a copy of all of the above data in an easy to obtain format: tux> isql employee Database: employee Chapter 4. Database Header Page — Type 0x01 11 SQL> show table mon$database; mon$database; MON$DATABASE_NAME (RDB$FILE_NAME) VARCHAR(253) Nullable MON$PAGE_SIZE (RDB$PAGE_SIZE) SMALLINT Nullable MON$ODS_MAJOR (RDB$ODS_NUMBER) SMALLINT

Junk = Set of Char; Days = (Mon, Tue, Wed, Thu, Fri, Sat, Sun); Var WorkDays : Set of days; Given these declarations, the following assignment is legal: WorkDays := [Mon, Tue, Wed, Thu, Fri]; Several operations: Type Day = (mon,tue,wed,thu,fri,sat,sun); Days = set of Day; Procedure PrintDays(W : Days); Const 180 CHAPTER 12. EXPRESSIONS DayNames : array [Day] of String[3] = ('mon','tue','wed','thu', Day; S : String; begin S:=''; For D:=Mon to Sun do if D in W then begin If (S<>'') then S:=S+','; S:=S+DayNames[D]; end; Writeln('[',S,']'); end; Const WorkWeek = [mon,tue,wed,thu,fri]; WeekEnd = [sat,sun];

rules. Rule name Description WEEKDAY business day frequency EOM business month end frequency W@MON weekly frequency (mondays) W@TUE weekly frequency (tuesdays) W@WED weekly frequency (wednesdays) number of observations in window required to have a value time_rule : {None, ‘WEEKDAY’, ‘EOM’, ‘W@MON‘, ...}, default=None Name of time rule to conform to before computing statistic Returns y : type number of observations in window required to have a value time_rule : {None, ‘WEEKDAY’, ‘EOM’, ‘W@MON‘, ...}, default=None Name of time rule to conform to before computing statistic Returns y : type

rules. Rule name Description WEEKDAY business day frequency EOM business month end frequency W@MON weekly frequency (mondays) W@TUE weekly frequency (tuesdays) W@WED weekly frequency (wednesdays) number of observations in window required to have a value time_rule : {None, ‘WEEKDAY’, ‘EOM’, ‘W@MON‘, ...}, default=None Name of time rule to conform to before computing statistic Returns y : type number of observations in window required to have a value time_rule : {None, ‘WEEKDAY’, ‘EOM’, ‘W@MON‘, ...}, default=None Name of time rule to conform to before computing statistic Returns y : type

rules. Rule name Description WEEKDAY business day frequency EOM business month end frequency W@MON weekly frequency (mondays) W@TUE weekly frequency (tuesdays) W@WED weekly frequency (wednesdays) number of observations in window required to have a value time_rule : {None, ‘WEEKDAY’, ‘EOM’, ‘W@MON‘, ...}, default=None Name of time rule to conform to before computing statistic Returns y : type number of observations in window required to have a value time_rule : {None, ‘WEEKDAY’, ‘EOM’, ‘W@MON‘, ...}, default=None Name of time rule to conform to before computing statistic Returns y : type

String Example of returned value (Unix): FreeBSD localhost 4.2-RELEASE FreeBSD 4.2-RELEASE #0: Mon Nov i386 Example of returned value (Windows): Windows ZABBIX-WIN 6.0.6001 Microsoft® Windows run: CREATE USER zabbix_mon IDENTIFIED BY ; -- Grant access to the zabbix_mon user. GRANT CONNECT, CREATE SESSION TO zabbix_mon; GRANT SELECT ON V_$instance TO zabbix_mon; GRANT SELECT ON V_$database V_$database TO zabbix_mon; GRANT SELECT ON v_$sysmetric TO zabbix_mon; GRANT SELECT ON v$recovery_file_dest TO zabbix_mon; GRANT SELECT ON v$active_session_history TO zabbix_mon; GRANT SELECT ON v$osstat TO