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

Query the allocated space and free space of the temporary tablespace:

Select tablespace_name

, tablespace_size/1024/1024 mb_size

, allocated_space/1024/1024 mb_alloc

, free_space/1024/1204 mb_free

From dba_temp_free_space; queries how a session uses temporary tablespaces:

SELECT s.sid,s.serial#,s.username

, p.spid,s.module,p.program

, SUM (su.blocks) * tbsp.block_size/1024/1024 mb_used

, su.tablespace

FROM

V$sort_usage su

, v$session s

, dba_tablespaces tbsp

, v$process p

WHERE

Su.session_addr = s.saddr

AND

Su.tablespace = tbsp.tablespace_name

AND

S.paddr = p.addr

GROUP BY

S.sid,s.serial#,s.username,s.osuser,p.spid,s.module

P.program,tbsp.block_size,su.tablespace

ORDER BY

S.sid

After you find that there is not enough temporary tablespace, you can use the following methods to resolve it:

1.resize

Alter database tempfile 'file' resize xxg

2.add tempfile

Alter database add tempfile 'file' size xxg

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.