My Oracle Support Banner

DBA_FREE_SPACE Does not Show Information about Temporary Tablespaces (Doc ID 188610.1)

Last updated on NOVEMBER 23, 2023

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 There are permanent and temporary tablespaces in the database. If you look for the amount of free space in these tablespaces through DBA_FREE_SPACE, only information about      PERMANENT tablespaces is displayed. The TEMPORARY tablespaces are not listed.

Changes

 No Changes

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.