8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Multitenant : Querying Container Data Objects (CONTAINER_DATA)


Liz said...

Tim, you saved me!

I'm using DataDog to monitor. Its agent can have only 1 login. I created a common user that logs into the CDB. It needs to read from PDB and CDB. When reading v$session from CDB, I needed a way to see all local user sessions. This alter saved me!

ALTER USER c##DATADOG SET CONTAINER_DATA=ALL CONTAINER=CURRENT;

Thanks!

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.