select sql_id, child_number, sql_text, sql_fulltext, parsing_schema_name -----①
, sharable_mem, persistent_mem ,runtime_mem -----②
, loads, invalidations, parse_calls, executions, fetches, rows_processed -----③
, cpu_time, elapsed_time-----④
, buffer_gets, disk_reads, sorts-----⑤
, application_wait_time, concurrency_wait_time-----⑥
, cluster_wait_time , user_io_wait_time-----⑥
, first_load_time, last_active_time -----⑦
from v$sql
where to_char(last_active_time,'yyyymmdd') = '20160908'

오라클 V$SQL에 관련해서 잘 설명한 블로그가 있어서 링크해놓는다.
http://doraeul.tistory.com/80 – 도래울님 블로그