Resources Window

The Resource window contains a list of all the resources available to the role of the person logged into the portal. Click on whitespace in a resource line and the Alerts window to the right will be filtered to show only alerts for the resource line you clicked on. Click directly on a given resource name to be redirected to the Trends Dashboard for that resource.

The list can be filtered using the Omnisearch Bar to reveal particular resources of interest. The list can be further grouped and sorted for browsing if you happen to administer a large number of resources.


To GROUP resources, click and drag any of the the Site, Resource, Environment, Type or HB Age column headers to the grouping line just above the header.

Here we have grouped by Site with the "demo0 "Site's resource list expanded:


You can click "Expand all" which now appears in the upper right corner of the window to reveal the resources under all the Sites shown instead of just the first one. Expand All changes to Collapse all when clicked and vice versa. To remove this grouping, click the x in the header box you dragged up to the grouping line.

To SORT simply click on the header you are interested in sorting by. Successive clicks on the header cycle through sorting alphabetically ascending, descending and default sort order. Here is the list in descending order:


Grouping and Sorting change the VIEW of the resources window. You can save a preferred view by clicking the "View" dropdown in the upper right corner of the Resources window. Click Save current view to name and save your view to the top of the view dropdown menu. You can also choose to un/set the default view you see whenever you arrive on the dashboard page. To delete a view click the trash barrel to the right of view name you saved earlier.


Each resource line contains a submenu of options for that resource. Right click on whitespace in the resource line of interest and this menu will be revealed:




Column Information
Cnx Number of connections to the Resource
Blocked Number of users blocked from the Resource
TRX Rate of transactions per second (commit rate)
Bkp Age Elapsed time since the last backup (dd hh:mm)
Lk Number of Resources locked
BI Cls Number of BI clusters in use
Hit% Buffer hit ratio. Percentage of Database Resource requests read from memory
Log Rd Logical reads per second
OS Rd OS reads per second
LatchTMO Number of latch timeouts
io Resp I/O response time