Oracle maintains a set of virtual tables that record current database activity. These tables are called dynamic performance tables.

This post was written by Sriram Sanka in his blog.

Why the term “Fixed”?

Because They are fixed ..One cannot perform any DML , DDL or any operation other than “SELECT“,that’s why these views/Tables are known as Fixed.

Oracle maintains some dynamic performance views which are dynamically created based on the “X$” tables.

Those are basically start with ‘V$’ and ‘GV$’ with one extra column “Instance_id”.

We can query of these views, to get more Info on these views


These are permanent tables/views.The X$ tables are generated when ever you instance started.
These tables are accessible to the SYS User only.These ‘X$‘ are not even modifiable By the Super User ‘SYS‘.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.