Use EM to view the tablespace View

Use EM to view the tablespace View

Now let's take a look at how to use EM to view the table space view.
Under Administration-Storage-Tablespaces, you can view table space indicators:

For example, the table space usage, total size, remaining space, and percentage are displayed. You can also perform simple operations on the table space. Click the table space name to View Details:


In addition, we can use the following SQL statement to query table space usage:

SELECT a. tb_name tablespace name,
C. contents type,
C. extent_management zone management,
B. total/1024/1024 tablespace size m,
(B. total-a. free_sp)/1024/1024 m used,
A. free_sp/1024/1024 remaining m,
Substr (B. total-a. free_sp)/B. total * 100, 1, 5) Utilization
FROM (SELECT tablespace_name tb_name, SUM (nvl (bytes, 0) free_sp
FROM dba_free_space
Group by tablespace_name),
(SELECT tablespace_name tb_name, SUM (bytes) total
FROM dba_data_files
Group by tablespace_name) B,
(SELECT tablespace_name tb_name, contents, extent_management
FROM dba_tablespaces) c
WHERE a. tb_name = B. tb_name
AND c. tb_name = B. tb_name;

The three data dictionary tables dba_free_space, dba_data_files, and dba_tablespaces respectively describe the tablespace free size, data file size, and table space usage.