Charting

This is a major piece of functionality, which may change the way you view the data in your databases.

  • to chart a table, display the table then click on the Chart button
  • this will show you the Chart Builder window, where you can define your chart in a few clicks.
  • you can Save your chart and reapply it to your data at a later time.
Building a chart in AQT

Saved Charts

Once you have saved a Chart:

  • it will appear in the Queries display in the Database Explorer window. You can easily view all the charts that you have developed and saved
  • you can define a Chart as a Favorite
  • the data behind the chart can be refreshed by right-clicking the chart and selecting Refresh
  • a saved Chart is contained within a file. This includes the definition of the Chart plus the query that was run to populate the data. Chart files can be manipulated like normal files - you can move them around on your machine or distribute them to your colleagues. A chart can operate both as snapshot of your data at a particular time, and as a pre-built query that you can deploy to other people.
  • charts can be created in an unattended batch script
Viewing a Chart as a Favorite in the Database Explorer

Charts in the Database Explorer

The Database Explorer comes with a number of pre-built charts. The following show both Tablespace Usage within an Oracle tablespace.

Charting in the Database Explorer