3.1.4.2.2.1.3.71.1 Columns

The DISCOVER_MEM_STATS rowset contains the following columns.

Name	Type	Restriction	Description
CATALOG_NAME	xsd:string	Yes	The name of the online database. The system tracker name is $System.
PARENT_TRACKER_TYPE	xsd:string		The type of the parent memory tracker. The available types are System and Database.
PARENT_TRACKER_NAME	xsd:string		The name of the parent memory tracker. The database tracker name is Database, and the system tracker name is $System.
PARENT_TRACKER_ID	xsd:string		The identifier of the parent memory tracker. The value is Database ID for the database tracker and $System for the system tracker.
CHILD_TRACKER_TYPE	xsd:string		The type of the child memory tracker. The available types are Database and Request.
CHILD_TRACKER_NAME	xsd:string		The name of the child memory tracker. The database tracker name is Database, the active request tracker name is $active, and the proxy tracker name is $proxy.
CHILD_TRACKER_ID	xsd:string		The identifier of the child memory tracker. The value is Database ID for the database tracker and request identifier for the request tracker.
OWNED_MEMORY_KB	xsd:long		The total amount of memory, in kilobytes, that is allocated for this tracker. This value is reported only for the active tracker.
OWNED_STORE_MEMORY_KB	xsd:long		This column SHOULD<364> indicate the total amount of memory, in kilobytes, that is used by stores.
ALLOCATIONS_COUNT	xsd:unsignedLong		The number of individual allocations that are tracked by the current child tracker.
REQUEST_PEAK_MEMORY_KB	xsd:long		The amount of peak memory, in kilobytes, that is allocated for the request tracker. This column is empty for the system and database trackers.

The rowset is sorted on CATALOG_NAME.

The response has the following definition.

 <xsd:element name="root">
   <xsd:complexType>
     <xsd:sequence minOccurs="0" maxOccurs="unbounded">
       <xsd:element name="row" type="row" />
     </xsd:sequence>
   </xsd:complexType>
 </xsd:element>
 <xsd:simpleType name="uuid">
   <xsd:restriction base="xsd:string">
     <xsd:pattern value="[0-9a-zA-Z]{8}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{12}" />
   </xsd:restriction>
 </xsd:simpleType>
 <xsd:complexType name="xmlDocument">
   <xsd:sequence>
     <xsd:any />
   </xsd:sequence>
 </xsd:complexType>
 <xsd:complexType name="row">
   <xsd:sequence>
     <xsd:element sql:field="CATALOG_NAME" name="CATALOG_NAME" type="xsd:string" 
                  minOccurs="0" />
     <xsd:element sql:field="PARENT_TRACKER_TYPE" name="PARENT_TRACKER_TYPE" type="xsd:string" 
                  minOccurs="0" />
     <xsd:element sql:field="PARENT_TRACKER_NAME" name="PARENT_TRACKER_NAME" type="xsd:string" 
                  minOccurs="0" />
     <xsd:element sql:field="PARENT_TRACKER_ID" name="PARENT_TRACKER_ID" type="xsd:string" 
                  minOccurs="0" />
     <xsd:element sql:field="CHILD_TRACKER_TYPE" name="CHILD_TRACKER_TYPE" type="xsd:string" 
                  minOccurs="0" />
     <xsd:element sql:field="CHILD_TRACKER_NAME" name="CHILD_TRACKER_NAME" type="xsd:string" 
                  minOccurs="0" />
     <xsd:element sql:field="CHILD_TRACKER_ID" name="CHILD_TRACKER_ID" type="xsd:string" 
                  minOccurs="0" />
     <xsd:element sql:field="OWNED_MEMORY_KB" name="OWNED_MEMORY_KB" type="xsd:long" 
                  minOccurs="0" />
     <xsd:element sql:field="OWNED_STORE_MEMORY_KB" name="OWNED_STORE_MEMORY_KB" 
                  type="xsd:long" minOccurs="0" />
     <xsd:element sql:field="ALLOCATIONS_COUNT" name="ALLOCATIONS_COUNT" 
                  type="xsd:unsignedLong" minOccurs="0" />
     <xsd:element sql:field="REQUEST_PEAK_MEMORY_KB" name="REQUEST_PEAK_MEMORY_KB" 
                  type="xsd:long" minOccurs="0" />
   </xsd:sequence>
 </xsd:complexType>