<\/p>\n
select sql_id, child_number, sql_text, sql_fulltext, parsing_schema_name -----\u2460\r\n, sharable_mem, persistent_mem ,runtime_mem -----\u2461\r\n, loads, invalidations, parse_calls, executions, fetches, rows_processed -----\u2462\r\n, cpu_time, elapsed_time-----\u2463\r\n, buffer_gets, disk_reads, sorts-----\u2464\r\n, application_wait_time, concurrency_wait_time-----\u2465\r\n, cluster_wait_time , user_io_wait_time-----\u2465\r\n, first_load_time, last_active_time -----\u2466\r\nfrom v$sql\r\nwhere to_char(last_active_time,'yyyymmdd') = '20160908'<\/pre>\n\uc624\ub77c\ud074 V$SQL\uc5d0 \uad00\ub828\ud574\uc11c \uc798 \uc124\uba85\ud55c \ube14\ub85c\uadf8\uac00 \uc788\uc5b4\uc11c \ub9c1\ud06c\ud574\ub193\ub294\ub2e4.
\nhttp:\/\/doraeul.tistory.com\/80 – \ub3c4\ub798\uc6b8\ub2d8 \ube14\ub85c\uadf8<\/p>\n","protected":false},"excerpt":{"rendered":"select sql_id, child_number, sql_text, sql_fulltext, parsing_schema_name —–\u2460 , sharable_mem, persistent_mem ,runtime_mem —–\u2461 , loads, invalidations, parse_calls, executions, fetches, rows_processed —–\u2462 , cpu_time, elapsed_time—–\u2463 , buffer_gets, disk_reads, sorts—–\u2464 , application_wait_time, concurrency_wait_time—–\u2465 , cluster_wait_time , user_io_wait_time—–\u2465 , first_load_time, last_active_time —–\u2466 from v$sql where to_char(last_active_time,’yyyymmdd’) = ‘20160908’ \uc624\ub77c\ud074 V$SQL\uc5d0 \uad00\ub828\ud574\uc11c \uc798 \uc124\uba85\ud55c \ube14\ub85c\uadf8\uac00 \uc788\uc5b4\uc11c \ub9c1\ud06c\ud574\ub193\ub294\ub2e4. http:\/\/doraeul.tistory.com\/80 – … Continue reading V$SQL \uc774\ub780?<\/span>