oracle脚本
-
编辑 删除
SQL占用TEMP
--16指的是blocksizeselect distinct tu.username,machine,sid,tablespace,blocks*16/1024 "USE(MB)",segtype,tu.sql_id,sql_textfrom(select username,session_addr,sqladdr,sqlhash,sql_id,tablespace,sum(blocks)...
-
编辑 删除
TEMP表空间使用率
11G下：select tablespace_name,round(free_space/1024/1024/1024,2) "free(GB)",round(tablespace_size/1024/1024/1024,2） "total(GB)",round(nvl(free_space,0)*100/tablespace_size,3) "Free percent"from dba_t...
