Checking the Default Temporary Tablespace in Oracle Database

#Query to check default temporary tablespace in Oracle database SQL> set lines 300 pages 3000 SQL> col property_name for a30 SQL> col property_value for a30 SQL> select property_name,property_value from database_properties where property_name='DEFAULT_TEMP_TABLESPACE' order by 1; PROPERTY_NAME             PROPERTY_VALUE ------------------------- ---------------- DEFAULT_TEMP_TABLESPACE   TEMP