Shulou(Shulou.com)06/01 Report--

Select h.tablespace_name tablespace_name,f.autoextensible

Round (sum (nvl (p.bytes_used, 0)) / power (2,30), 2) used_gb

Round (sum (decode (f.autoextensible, 'YES', f.maxbytes,' NO', f.bytes)) / power (2,30), 2) max_gb

From v$temp_space_header h, v$temp_extent_pool p, dba_temp_files f

Where p.file_id (+) = h.file_id

And p.tablespace_name (+) = h.tablespace_name

And f.file_id = h.file_id

And f.tablespace_name = h.tablespace_name

Group by h.tablespace_name,f.autoextensible

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.