My Oracle Support Banner

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

Last updated on AUGUST 28, 2018

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

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

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


In this Document
  Goal
  Solution

Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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