You can customize your system monitor displays. From the System Monitor window, go Customize > Main Grid (or Right Grid / Bottom Grid).
You will be shown the following window:
This window shows how the System Monitor window is defined within AQT. There are two parts to this:
Columns in the Display. This specifies the columns in the system monitor display, and how they are defined
Query. This show the query that is run to populate the data in the display
Columns in the Display
Caption. This gives the caption (column heading) of the column in the display
Query Col. This specifies the column (in the query) which populates the column. You can either specify a column-number or column-name.
Function. In some circumstances, AQT formats the returned data value using an internal AQT function; this specifies this function. Generally you would not to wish to change this.
Display Type. How the value is to be displayed. You would normally specify Normal. Use Check Box to specify a check box (in which case the query should return 1 or 0). Use Text Box to display a large text value (this is only used for displaying SQL text).
Data Type. Specify char (character), num (numeric) or perc (percentage). perc will take a value such as 0.4512 and display it as 45.12%
Hidden. Whether the column is to be displayed. If you wish to remove a column from the display, it is recommended that you check this box rather than removing the column.
Warning. Specifies a warning condition - when this is met the value is highlighted in yellow. This is discussed below.
Crit. Specifies a critical condition - when this is met the value is highlighted in red. This is discussed below.
You can:
change the order of columns in the display by dragging them up or down. You should not move the first column away from that position, as it is often used as a key into other displays.
delete columns (though it is recommended that you Hide them instead)
add new columns. You would generally need to amend the Query (to return the extra data) as well as doing this.
Query
This gives the query that is run to populate the data in the display. It is recommended that you do not change this except:
you can change the Order By statement to display the data in a different order
you can add more columns to the query. Do these at the end of the current column list
you can add a Where clause to restrict the number of rows returned by the query. Use this with caution however, as some queries (particularly those used for the right/bottom grids) automatically have Where clauses added to them by AQT. If you add a Where clause, a syntax error will result.
Make sure that you test the query thoroughly before making changes to it.
Warn and Crit
These give conditions when a cell value will be highlighted in Yellow and Red respectively. These are coded as follows:
Specification
What it Does
x
Cell value equals x
*x
Cell value contains x
<>x
Cell value is not x
>x
Cell value is greater than x
<x
Cell value is less than x
>=x
Cell value is greater or equal to x
<=x
Cell value is less than or equal to x
You can have multiple conditions separated by commas, eg. x,y,*z (there will be a match if the cell value is either x or y or contains z).
If you use View > Two-Color Display, the cells will not show the highlight color (this is overridden by the two-color display).
OK
When you click on OK, the display is saved as a Customized display.It will be held in a user-customized administration configuration file. The name will be (for instance) oracle_adm_usr.cfg in your Config File Directory.
Reload
Click on this if you have amended the display and want it returned to it's original state (eg the state it was when you opened this window).
Revert to Default
This button is active if the display you are dealing with is a customized display. When you click on this button, the display will revert back to the original state.
Further Customization
The system monitor is configured as part of the Administration Component of AQT. The "full" configuration window can be accessed from the Database Explorer Window Tools > Configure Admin Component. The Customize Display window is a cut-down version of Configure Admin Component window. If you wish to configure further aspects of the System Monitor, you should use the Configure Admin Component window.
