1.1

ContentsNullableLengthTypeColumn Name
Note used.No128VARCHARROLES
Host and port information
for Network Servers that
No32672VARCHARNETSERVERS
are running on SQLFire
members.
Host and port information
for locator members.
No32672VARCHARLOCATORS
A comma-separated list of
server groups of which
this member is a part.
No32672VARCHARSERVERGROUPS
A list of all system
properties used to start this
No2147483647CLOBSYSTEMPROPS
member. This includes
properties such as the
classpath, JVM version,
and so forth.
The names and values of
GemFire core system
No2147483647CLOBGEMFIREPROPS
properties that the member
uses. See Configuration
Properties on page 315 for
property descriptions.
All of the SQLFire boot
properties names and
No2147483647CLOBBOOTPROPS
values that a member uses.
See Configuration
Properties on page 315 for
property descriptions.
MEMORYANALYTICS
A SQLFire virtual table that provides information about the overhead and memory usage of user tables and
indexes.
See Estimating Memory Requirements on page 71.
Table 15: MEMORYANALYTICS system table
ContentsNullableLengthTypeColumn Name
The full name of the table
or index, as well as the
No64VARCHARSQLENTITY
names of the memory
values displayed in the
MEMORY column.
The SQLFire member to
which the memory values
apply.
No128VARCHARID
The actual memory values,
separated by commas.
No2147483647LONG VARCHARMEMORY
STATEMENTPLANS
A SQLFire virtual table that stores query execution plans and timing information for SQL statements executed
with the EXPLAIN command (or for statements executed on a connection that enables query plans and statistics
641
System Tables