“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“,thats why these views/Tables are known as Fixed. ind> select banner from v$version; BANNER —————————————————————- Oracle … Continue reading Oracle Fixed(/Dynamic) views