In the Oracle database Management of LOB objects category, you will find some queries to identify tables with LOB fields and their size.
Large Objects (LOBs) are a set of data types designed to hold large amounts of data, such as documents, audio files, video files, and so on.
The functionality of Large Objects allows storing these types of data in the database and in the file systems of the operating system accessed from the database.
A Large Object can have a maximum size ranging from 8 terabytes to 128 terabytes, depending on the database configuration. Therefore, good space organization is necessary to avoid future issues.
Follow the articles in the Oracle database Management of LOB objects category.
With the article “Oracle Table LOB Query,” we provide a query that allows you to see the size of LOBs in a table. In the Oracle database, LOBs are large object objects. LOBs are divided into 2 categories: CLOB and BLOB: CLOB – Character Large Object BLOB – Binary Large Read more…
With the article “LOB Segment Oracle Query,” we provide a query that allows you to see the size of the LOB segment of a table. As explained in the article Query Oracle Table LOB Query, LOBs are large objects that are divided into CLOB and BLOB. These objects can reach enormous Read more…