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

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

Conclusion:

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: www.linkedin.com/in/skantali/

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