Forum Stats

  • 3,839,355 Users
  • 2,262,485 Discussions
  • 7,900,946 Comments

Discussions

Any CDB view for database_properties? Looking for DST information on all of my PDBs

user548445
user548445 Member Posts: 16 Blue Ribbon

Hi, I have a multitenant architecture in 12c (upgrading this month) and 19c. I wrote this script:

SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value

        FROM DATABASE_PROPERTIES

        WHERE PROPERTY_NAME LIKE 'DST_%'

        ORDER BY PROPERTY_NAME;

But it only returns results for current PDB. I'm not seeing a CDB_DATABASE_PROPERTIES option. Is there another way? I know about catcon.pl but that is a bit messy in my environment (cpu count of 64 means 170+ files get created everytime and data is spread throughout) so I'm really just looking for a simple view I can query. Thanks.

🦉

Best Answer

Answers