[Oracle Script] Temporary Sort Usage
SELECT s.sid sid, s.serial# serial, s.module module, s.program program, s.event, SUM(su.blocks) temp_blocks,
trunc(SUM(su.blocks) * 8096 / 1024 / 1024) temp_size , sql.sql_text
FROM v$sort_usage su, v$session s ,v$sql sql
WHERE su.session_addr = s.saddr and s.sql_id=sql.sql_id
GROUP BY s.sid, s.serial#, s.module, s.program , s.event, sql.sql_text
trunc(SUM(su.blocks) * 8096 / 1024 / 1024) temp_size , sql.sql_text
FROM v$sort_usage su, v$session s ,v$sql sql
WHERE su.session_addr = s.saddr and s.sql_id=sql.sql_id
GROUP BY s.sid, s.serial#, s.module, s.program , s.event, sql.sql_text
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-2143820/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [Oracle Script] Rollback Segment UsageOracle
- [Oracle Script] check tablespace usage infoOracle
- [Oracle Script] check temp tablespace usageOracle
- [Oracle Script] Undo Usage Per statusOracle
- [Oracle Script] Undo Usage Per sessionOracleSession
- V$sort_usage, where is the definition?
- Elasticsearch script sort 排序Elasticsearch排序
- oracle global temporary table全域性臨時表_測試及v$tempseg_usageOracle
- oracle temporary tableOracle
- oracle scriptOracle
- Oracle runInstaller 's UsageOracle
- Oracle NUMA usage recommendationOracle
- Oracle Temporary Tables(Oracle 臨時表)Oracle
- elasticsearch實現簡單的指令碼排序(script sort)Elasticsearch指令碼排序
- 【Oracle九大效能檢視】之8.v$sort_usage temp表空間的使用情況Oracle
- Oracle Sort JoinOracle
- Temporary tablespaces in RAC ? Oracle databas...Oracle
- Oracle 11g tablespace usageOracle
- [Oracle Script] LockOracle
- Oracle Database ScriptOracleDatabase
- Script:List SORT ACTIVITY監控臨時空間的使用
- Oracle臨時表GLOBAL TEMPORARY TABLEOracle
- oracle的兩種global temporary table!Oracle
- Oracle NUMA Usage Recommendation [ID 759565.1]Oracle
- [Oracle Script] Top sqlOracleSQL
- [Oracle Script] check userOracle
- [Oracle Script] check latchOracle
- Oracle kill session scriptOracleSession
- ORACLE常用Script(轉)Oracle
- ORACLE常用Script (轉)Oracle
- v$SORT_USAGE.SQL_ID 不是會話當前的執行的SQL IDSQL會話
- V$TEMPSEG_USAGE與Oracle排序Oracle排序
- [Oracle Script] check active sessionOracleSession
- [Oracle Script] Log switch statusOracle
- [Oracle Script] check lock infoOracle
- [Oracle Script] latch holderOracle
- [Oracle Script] check Literal SQLOracleSQL
- Allocation of Temporary Segments for Temporary Tables and Indexes (28)Index