In the Oracle database, there are many views which can be queried to acquire data about the database state. They are divided into data dictionary views, with a name similar to
DBA_*, and dynamic performance views, named something similar to
When we use a standard template in Oracle DBCA to create a database, both data dictionary views and dynamic performance views are in place after database creation. If we prefer to use our own scripts to create the database, we need to launch at least the
catproc.sql scripts to populate the data dictionary with the views we need. These scripts are located in the
rdbms/admin subdirectory of the Oracle Home ...