query to get complete list of v$ and DBA_ tables in a pdb
hi,
1)
Is there a query to show all the V$ and DBA_ for a pdb while logged in as pdb user with dba privs?
2)
when logged in as dba privileges in pdb I get 16 rows in dict (whatever that is) and 5 rows on dba_tables.
wasn't dict view based on dba_tables???
When running from a pdb - 16 rows
select count(*)from dictwhere table_name like '%V$%';
When running from a pdb - 5 rows
select count(*)from dba_tableswhere table_name like '%V$%';
Oracle 19c
Linux 7
I'm not sure why oracle is so unnecessary complicated or why no one I know knows this.