1. Operations Guide
  2. Working with Data in a TimesTen Database
  3. Understanding System Views

Understanding System Views

There are several local (V$) global (GV$) system views you can query to retrieve metadata information about your database.

In TimesTen Scaleout:

  • The V$ views contain data for the element to which your application is connected.

  • The GV$ views contain the contents of the V$ view for every element of the database.

In TimesTen Classic:

  • The V$ views contain rows of data for the database to which your application is connected.

  • The GV$ views contain the same contents as their corresponding V$ view.

In addition, there are several views that you can query that are based on TimesTen built-in procedures. See System Tables and Views in the Oracle TimesTen In-Memory Database System Tables and Views Reference.