V$FIXED_TABLE

This view lists all V$ and X$ Dynamic Performance Views.

Fields

The most relevant view fields are as follows:

  • NAME: The object name
  • OBJECT_ID: The object identification number
  • TYPE: The object type; can be TABLE or VIEW
  • TABLE_NUM: If the type is TABLE, it identifies the dynamic performance table

Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial