Database Administration (MOSC)

MOSC Banner

Tablespace monitoring Oracle 12c

edited Aug 28, 2019 9:06AM in Database Administration (MOSC) 8 commentsAnswered ✓

Good morning,

I hope again to write in the right Space.

I have e 12C container instance with a single PDB:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit.

I need to query cdb_data_files (and also segments, tablespaces and some other) for monitoring pourposes.

With Oracle 10 and 11 I used to query DBA_DATA_FILES (tablespaces, segments and so on), I want informations about CDB's and PDB's occupancy so I decided to use CDB_ views.

When I connect as sysdba the query

select distinct CON_ID from cdb_data_files

shows me 1 and 3 (the single PDB) .

I created a user in the container

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