Database Administration (MOSC)

MOSC Banner

query to get complete list of v$ and DBA_ tables in a pdb

edited Jan 22, 2020 2:49PM in Database Administration (MOSC) 4 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center