DATABASE_PROPERTIES

DATABASE_PROPERTIES lists the current default temporary tablespace name.

Column	Datatype	NULL	Description
PROPERTY_NAME	VARCHAR2(30)	NOT NULL	Property name of the default temporary tablespace
PROPERTY_VALUE	VARCHAR2(4000)		Property value of the default temporary tablespace
DESCRIPTION	VARCHAR2(4000)		Property description of the default temporary tablespace