In Oracle, a schema is a collection of database objects such as tables, views, indexes, and stored procedures that belong to a particular user or group of users. The schema size refers to the amount of storage space that is occupied by these objects. Checking the schema size is important for several reasons. It helps ensure that the database is not running out of space and that the data is being stored efficiently. Additionally, it can help identify any unused or unnecessary objects that can be removed to free up space. There are several ways to check the schema size in Oracle. One common method is to use the following query:
SELECT owner, tablespace_name, SUM(bytes) AS schema_sizeFROM dba_segmentsWHERE owner = ‘USERNAME’GROUP BY owner, tablespace_name;