Oracle database - Explain how to find used/free space in a TEMPORARY tablespace
posted by Babu Kunwar
Explain how to find used/free space in a TEMPORARY tablespace
You can easily compute the amount of free space in each tablespace by using the
following query:
SQL> select tablespace_name, sum (bytes) from dba_free_space group by
tablespace_name;
Remember: The free space does not take into account the space that would be
available if and when the datafiles in a tablespace are auto extended. Also,
any space allocated to a table for rows that are later deleted will be
available for future inserts into the table, but it is not counted in the
preceding query results as space available for other database objects.
More links
Explain subqueries with an example - A subquery is a query within a query. The
inner query is processed first. They are most commonly used to return data from
multiple tables when the exact value is not known................
|
