> ### Understanding OpenEdge database views

> 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 FathomTrendDatabase.) 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, such as pie graphs or column graphs (for more information about graphical displays of data, see Chapter 2, "Graphical Displays of Database Data"). Views created for scripted databases do not contain graphical displays of 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 refreshes.

> Database views are organized into three overall categories: Operations views, Informational views, and Advanced views. Table 3–2 lists and describes all database views, and indicates if the view can be created for both managed and scripted databases or for only managed databases.

> Table 3–2: Database views
> View name | Database type | Description
> --- | --- | ---
> 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: 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.

> Note: You access the above views from the Database Details page.

Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095