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, Request, SessionScope, GlobalScope, and SEScope.<375>

CHILD_TRACKER_NAME

xsd:string

The name of the child memory tracker. The database tracker name is the Database ID, the active request tracker name is $Active, the proxy tracker name is $Proxy, the system tracker name is $System, and the scope trackers’ names are $Active.

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 and scope trackers.

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<376> 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>
  • Last updated on