Difference between revisions of "Show temp tablespace usage"
		
		
		
		
		
		Jump to navigation
		Jump to search
		
			
		
		
	
 (Created page with "SELECT b.tablespace,        ROUND(((b.blocks*p.value)/1024/1024),2)||'M' AS temp_size,        a.inst_id as Instance,        a.sid||','||a.serial# AS sid_serial,        NVL(a.u...")  | 
			
(No difference) 
 | 
Revision as of 13:25, 28 April 2016
SELECT b.tablespace,
      ROUND(((b.blocks*p.value)/1024/1024),2)||'M' AS temp_size,
      a.inst_id as Instance,
      a.sid||','||a.serial# AS sid_serial,
      NVL(a.username, '(oracle)') AS username,
      a.program,
      a.status,
      a.sql_id
FROM gv$session a,
      gv$sort_usage b,
      gv$parameter p
WHERE p.name = 'db_block_size' AND a.saddr = b.session_addr AND a.inst_id=b.inst_id AND a.inst_id=p.inst_id ORDER BY b.tablespace, b.blocks /