How to Monitor Space Usage in the Database Schema Service (Doc ID 2113602.1)

Last updated on AUGUST 09, 2017

Applies to:

Oracle Database Cloud Service - S50 - Version N/A and later
Oracle Database Cloud Service - S20 - Version N/A and later
Oracle Database Cloud Service - S5 - Version N/A and later
Information in this document applies to any platform.

Goal

We received an "ORA-01691 : unable to extend lob segment FQBPQJYGJ12CN.SYS_LOB0000175888C00003$$ by 1024 in tablespace" when loading data into our service. We have discovered that we have exceeded the space allocated for this service. Upgrading to another service is not an option.

How do we know the current database size and which tables are occupying the most space. Is there a report in DBCS that can help us with this?
 

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