Answers for "Temp Space"

SQL
0

Temp Space

select tablespace_name,status,contents from dba_tablespaces where contents='TEMPORARY';
Posted by: Guest on November-02-2021
0

Temp Space

select tablespace_name, ' %free='|| round(sum(free_blocks) / sum(total_blocks) * 100 ,0)
from gv$sort_segment group by tablespace_name;
Posted by: Guest on November-02-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language