The various database views display data about key database components so that you can assess what is happening with the databases. The database agent gathers data for the views by polling the database's Virtual System Tables (VSTs). (View data does not come from the OpenEdge Management Trend Database.) For more information on VSTs, see OpenEdge Data Management: Database Administration.

Views capture information at a specific point in time. Because database status can change from moment to moment, refresh the detail frame to keep the view's data current. All views display the date and time they were built.

Different database views appear in different formats; some include graphical displays of data. Views created for scripted databases do not contain graphical displays of data. For more information about graphical displays of data, see Graphical Displays of Database Data.

Some views allow you to narrow the scope of data by clicking on any underlined subject. Note that underlined subjects behave differently than the underlined column headings. Clicking an underlined column heading does not bring you to a more detailed view of the subject; instead, it changes the column's sort order. If the default sort order for a column is ascending, clicking the heading will change the sort to descending. If the default sort order is descending, clicking the heading will make it ascending. Note that when you change the sort order, the page automatically refreshes.

Database views are organized into three overall categories: Informational views, Operational views, and Advanced views. The following table lists and describes all database views, and indicates whether the view can be created for both managed and scripted databases or only for managed databases.

To access the database views, click Resources > Go to Resources and select the required database using the filtering or search options. You can find the following database views on the Database details page:

Table 1. Database views
View name Database type Description
Database configuration Configuration details of the database
Performance Summary Summary information of buffers, records, transactions, page writers, locks, and connections
Vital Signs Managed and scripted Summary of important database information
File Systems Managed List of file systems and associated files that the database uses (not available for remote databases)
Storage Areas Managed and scripted Storage area and extent information and statistics
User Activity Managed and scripted Information about connected users and user statistics
Record and Index Activity Managed and scripted I/O activity for tables and indexes
Locks and Latches Managed and scripted Information about lock and latch activity
Transactions Managed and scripted Information about database transactions
Memory Resources Managed and scripted Summary of buffers, memory, etc.
Page Writers Managed and scripted Summary of page writer activities
Start Parameters Managed and scripted Detail about the database start parameters
General Details Managed and scripted General information about the database, such as start, backup, etc.
Raw VST Data Managed and scripted Examination of individual VST tables
Raw System Table Data Managed and scripted Examination of individual system tables