My Oracle Support Banner

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

Last updated on DECEMBER 02, 2022

Applies to:

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

Goal

We received an "ORA-01691 : unable to extend lob segment <SCHEMA>.SYS_LOB<ID>$$ 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

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
References


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