Property System


There are several types of properties in dbWatch.

Dynamic properties

Dynamic properties are defined in xml files located in the [dbWatch Server]/server/resources/properties/ catalog.

You cannot add files to this catalogue manually, but import them by placing them in the [dbWatch Server]/server/resources/import_area catalog.

This file contains properties in the following format:

<property>
  <key>version</key>	
  <compatability>instance[databasetype='oracle']</compatability>
  <value engine="sql">select VERSION from v$instance</value>
  <valid-for>24h</valid-for>
</property>	
<property>
  <key>active_session_count</key>
  <compatability>instance[databasetype='oracle']</compatability>
  <value engine="sql">select count(*) from v$session where status = 'ACTIVE' and username is not null</value>
  <valid-for>5m</valid-for>
</property>

The fields are

Accessing properties

All properties can be queried using DBWQL, for example: