How to Find Database Properties in Oracle
In this article, we will prepare a script for How to Find Database Properties in Oracle. Using the view DATABASE_PROPERTIES, we can fetch the default values of the database like the default permanent & temporary tablespace, dictionary endian type, character set, global database name, etc.
Execute the below to fetch database properties.
SET PAGES 111
COL PROPERTY_NAME FOR A31
COL PROPERTY_VALUE FOR A35
SELECT PROPERTY_NAME, PROPERTY_VALUE FROM DATABASE_PROPERTIES ORDER BY PROPERTY_NAME;
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
We always encourage the technical person to visit section SCRIPTS to get more daily usage SQL commands.
Hope so you like this Script!
Please share your valuable feedback/comments/subscribe and follow us below and don’t forget to click on the bell icon to get the latest update. Click here to know more about our pursuit.
