sqlarea 쿼리 확인
SELECT * FROM ( SELECT INST_ID, SQL_ID, HASH_VALUE, PARSING_SCHEMA_NAME SCHEMA, LENGTH(SQL_FULLTEXT) SQL_LENGTH, MODULE, BUFFER_GETS, EXECUTIONS, ROUND(BUFFER_GETS/DECODE(EXECUTIONS, 0, NULL, EXECUTIONS)) "BUFFER_GET/EXEC", ROUND(DISK_READS/DECODE(EXECUTIONS, 0, NULL, EXECUTIONS)) "DISK_READ/EXEC", ROUND(ROWS_PROCESSED/DECODE(EXECUTIONS, 0, NULL, EXECUTIONS)) "ROWS_PROCESSED/EXEC", ROUND(PARSE_C..
2022. 7. 21.