Database Properties

Here is a query to view important database properties like default permanent, default temporary tablespaces, NLS settings etc.

SQL> Select * From Database_Properties;

Thanks