오라클 쿼리 로그 뷰

오라클 쿼리 로그 뷰

select * from v$sql

select * from v$sqltext

select * from v$sqlarea

select * from v$sql
 where parsing_schema_name = 'USER'
   and last_active_time > TO_DATE('2007/07/31 08:50','RRRR/MM/DD HH:MI' )
   and last_active_time < TO_DATE('2007/07/31 08:11','RRRR/MM/DD HH:MI' )
 order by last_active_time desc ;