The Database Schemas window is available only for Oracle database servers.

The Database Databases window is available for other database servers.

The database Schemas or Databases window shows you the names of the Top N busiest schemas or databases on the database server. To see the Top N Queries run on a specific Database or Schema, click a name and then click View Top Queries. From the Schema or Database top queries page, to see more details about a query you can double-click a query to open the Query Details window. 

Access the Database Schemas or Databases Window

To access the Database Schemas or Database window:

  1. From the AppDynamics Home page, on the Databases card, click the name of the database that you want to view the schemas or databases for.
  2. Depending on the platform, click either the Schemas or Databases tab.

Database Schemas or Databases Window Features

From the Database Schemas and Databases window you can:

  • Choose to view information for the top 10, 50, 100 or 200 schemas or databases containing the most time spent executing queries by the database server.
  • Double click the name of a schema or database to view the top queries for one schema database in particular, or select the schema or database and click View Top Queries.
  • Click the down arrow next to the Database Collector name at the top of the page to choose to view the database schemas or databases of a different database Collector by either selecting the database Collector from the list or by searching for the database Collector by entering text in the search bar and then clicking the refresh icon to show only database Collectors that meet that search criteria.

  • Click Actions to export the data on this window in a .csv formatted file that is automatically downloaded to your specified downloads directory.

From the Database Schemas or Databases window, you can view:

  • Schema or database: The names of the schemas or database on the database server.
  • Weight (%): The percentage of time the schema or database was used by the database server in comparison with the usage percentage of other schemas or databases.

Database Schema