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.
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?
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