/SQL/Temp Space

Temp Space

Temp Space

select tablespace_name, ' %free='|| round(sum(free_blocks) / sum(total_blocks) * 100 ,0)
from gv$sort_segment group by tablespace_name;

0

Source: techgoeasy.com

Temp Space

select tablespace_name,status,contents from dba_tablespaces where contents='TEMPORARY';

0

Source: techgoeasy.com

Similar codes

0 vote265 views1 answer
Ffeathers express mysql application users login
SQL
3 votes306 views2 answers
How to force truncate a table in mysql
SQL
0 vote258 views1 answer
Oracle list chain steps
SQL
6 votes296 views2 answers
Difference between join vs union
SQL
0 vote268 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote308 views1 answer
Suhaib
SQL
0 vote268 views1 answer
Postgre admin slow
SQL
0 vote291 views1 answer
Sql server remove primary key without dropping table
SQL
0 vote290 views1 answer
Oracle select partition
SQL
10 votes296 views2 answers
SQL rounding numbers
SQL

Share