How to check which is a specific tablespace usage ? (Doc ID 781526.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Financials Common Country - Version: 11.5.8 to 12.0.6 - Release: 11.5 to 12
Information in this document applies to any platform.
Financials Common Country - Version: 11.5.8 to 12.0.6
TABLESPACE
TABLE:DBA_FREE_SPACE
TABLE:DBA_DATA_FILES
USAGE
BYTES

Goal

Some times we get an error about lack of space in some tablespace. We must increase that tablespace by adding space to one of his data files. So, we must check which space exists in each of his data files, to decide to which we will increase/add space.
How to check which is a specific tablespace usage ?

Solution

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 hundreds of Community platforms