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 theV$
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 correspondingV$
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.