In the Oracle Tablespace management category, there are numerous queries available to identify the space usage of tablespace and individual data files.
In addition, there are dynamic queries to reclaim allocated but unused space.
TABLESPACE is the highest logical structure in the Oracle database where objects such as tables, indexes, views, etc. are stored.
Tablespace sizes
The size of a tablespace is determined by the number and size of the data files.
Oracle logically stores data in TABLESPACE and physically stores it in datafiles.
Data write and read performance
In a large database, poor data organization can result in significant performance problems.
To properly distribute data, Oracle recommends creating a specific TABLESPACE for each type of object.
Oracle best practices
Another best practice is to create datafiles for index TABLESPACES in a different file system or ASM disk group than the datafiles for tables.
In the Oracle TABLESPACE Management category, there are numerous queries available to identify the space usage of tablespace and individual data files.
Encountering issues with queries?
Don’t hesitate to contact us!
With the article Query size datafiles of a tablespace, we will explain how to identify the sizes of each individual data file in a tablespace. With this query, it is possible to understand if a data file has reached its maximum size or if it still has extents available. Let’s Read more…
With the article “Query to retrieve disk space allocated by DATAFILES but not used”, we provide a statement that allows you to recover disk space, so in case of emergency, we can try to recover some unused GB from the TABLESPACE. Before we start with the article “Query to retrieve Read more…
With the article “Query to see the size of all Oracle TABLESPACE” it will be possible to identify all the dimensions relating to the TABLESPACE. The selected fields are: TABLESPACE_NAME – Name of the tablespaces TOTAL_AUTO_MB – Total space of the Tablespace in MB TOTAL_NOW_MB – Total allocated space of Read more…
With the article “Query to View TEMPFILE and TEMP TABLESPACE Sizes,” you can locate the TEMP TABLESPACE. Welcome to scriptdba.com and, more specifically, to the article discussing the Query for TEMP TABLESPACE sizes! Additionally, you can identify the associated temp files and their respective sizes. Therefore, we can add temp files Read more…