Search notes:

$ORACLE_HOME/rdbms/admin/cdfixed.sql

Create V_$ views, V$ synonyms for dynamic performance views and grant select on the synonyms to select_catalog_role.
The script consists of a series of three statements for each(?) fixed view like so:
create or replace view v_$database as select * from v$database;
create or replace public synonym v$database for v_$database;
grant select on v_$database to select_catalog_role;

See also

cdbfixed.sql which installs CV$ views.

Index