SELECT INITIAL_EXTENT,NEXT_EXTENT,MIN_EXTENTS,PCT_INCREASE FROM SYS.DBA_TABLESPACES WHERE TABLESPACE_NAME='TEMP';
--查看哪些会话在使用临时段 SELECT * FROM v$session a, v$sort_usage b WHERE a.SADDR = b.SESSION_ADDR; --查看临时段上执行的SQL SELECT * FROM v$sort_usage a, v$sql b WHERE a.SQLHASH = b.HASH_VALUE;
FROM SYS.DBA_TABLESPACES WHERE TABLESPACE_NAME='TEMP';
SELECT * FROM v$session a, v$sort_usage b WHERE a.SADDR = b.SESSION_ADDR;
--查看临时段上执行的SQL
SELECT * FROM v$sort_usage a, v$sql b WHERE a.SQLHASH = b.HASH_VALUE;