3.1.4.2.2.1.3.72.1 Columns

The DISCOVER_DB_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.

DATABASE_ID

xsd:string

The identifier of the online database.

DATABASE_GUID

uuid

The GUID of the online database. The value is empty for the system tracker.

CURRENTLY_USED

xsd:boolean

A Boolean that indicates whether any requests are currently running against this database. The value is empty for the system tracker.

POPULARITY

xsd:float

A measure of how frequently the database is used. The value is empty for the system tracker.

WEIGHTEDPOPULARITY

xsd:double

A measure of how frequently the database is used, expressed as a fraction with respect to the other databases. The value is empty for the system tracker.

OWNED_MEMORY_KB

xsd:long

The total amount of memory, in kilobytes, that is owned by the database or system, including all of the proxy requests memory that was transferred to the database tracker.

ACTIVE_REQUESTS_MEMORY_KB

xsd:long

The total amount of memory, in kilobytes, that is owned by the active request trackers.

ACTIVE_REQUESTS_COUNT

xsd:unsignedInt

The number of active requests that are running against the database or the system tracker.

PROXY_REQUESTS_MEMORY_KB

xsd:long

This column SHOULD<378> indicate the total amount of memory, in kilobytes, that is used by proxy request trackers.

PROXY_REQUESTS_COUNT

xsd:unsignedInt

The number of request trackers that are proxies of the current database.

PROXY_REQUESTS_ALLOCATIONS_COUNT

xsd:unsignedLong

The number of individual allocations tracked by the requests trackers that are proxies of the database or system tracker.

DB_PROXY_TRACKERS_COUNT

xsd:unsignedInt

The number of database trackers that are proxies of the system tracker. This value is reported only by the system tracker.

DB_PROXY_TRACKERS_ALLOCATIONS_COUNT

xsd:unsignedLong

The number of individual allocations tracked by database trackers that are proxies of the system tracker This value is reported only by the system tracker.

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="DATABASE_ID" name="DATABASE_ID" type="xsd:string" 
                  minOccurs="0" />
     <xsd:element sql:field="DATABASE_GUID" name="DATABASE_GUID" type="uuid" minOccurs="0" />
     <xsd:element sql:field="CURRENTLY_USED" name="CURRENTLY_USED" type="xsd:boolean" 
                  minOccurs="0" />
     <xsd:element sql:field="POPULARITY" name="POPULARITY" type="xsd:float" minOccurs="0" />
     <xsd:element sql:field="WEIGHTEDPOPULARITY" name="WEIGHTEDPOPULARITY" type="xsd:double" 
                  minOccurs="0" />
     <xsd:element sql:field="OWNED_MEMORY_KB" name="OWNED_MEMORY_KB" type="xsd:long" 
                  minOccurs="0" />
     <xsd:element sql:field="ACTIVE_REQUESTS_MEMORY_KB" name="ACTIVE_REQUESTS_MEMORY_KB" 
                  type="xsd:long" minOccurs="0" />
     <xsd:element sql:field="ACTIVE_REQUESTS_COUNT" name="ACTIVE_REQUESTS_COUNT" 
                  type="xsd:unsignedInt" minOccurs="0" />
     <xsd:element sql:field="PROXY_REQUESTS_MEMORY_KB" name="PROXY_REQUESTS_MEMORY_KB" 
                  type="xsd:long" minOccurs="0" />
     <xsd:element sql:field="PROXY_REQUESTS_COUNT" name="PROXY_REQUESTS_COUNT" 
                  type="xsd:unsignedInt" minOccurs="0" />
     <xsd:element sql:field="PROXY_REQUESTS_ALLOCATIONS_COUNT" 
                  name="PROXY_REQUESTS_ALLOCATIONS_COUNT" type="xsd:unsignedLong" 
                  minOccurs="0" />
     <xsd:element sql:field="DB_PROXY_TRACKERS_COUNT" name="DB_PROXY_TRACKERS_COUNT" 
                  type="xsd:unsignedInt" minOccurs="0" />
     <xsd:element sql:field="DB_PROXY_TRACKERS_ALLOCATIONS_COUNT" 
                  name="DB_PROXY_TRACKERS_ALLOCATIONS_COUNT" type="xsd:unsignedLong" 
                  minOccurs="0" />
   </xsd:sequence>
 </xsd:complexType>
  • Last updated on