Oracle 실행된 쿼리 보기

실행된 쿼리 보기 :
    select * from v$sql where rownum < 10 and parsing_schema_name like 'PFM4ORA' order by first_load_time desc;
    select * from v$sqltext where rownum < 10;
    select * from v$sqlarea where rownum < 10 and parsing_schema_name like 'PFM4ORA' order by first_load_time desc;


SHARED_POOL CLEAR : 실행된 쿼리로그 날리기(v$sqlarea가 비워짐)
SQL> conn / as sysdba
SQL> alter system flush shared_pool;


exsample)
    select * from v$sqlarea where rownum < 10 and parsing_schema_name like 'PFM4ORA' order by first_load_time desc;
    select * from v$sqlarea where parsing_schema_name like 'PFM4ORA' order by first_load_time desc;
    select * from v$sqlarea  order by first_load_time desc;
    select * from v$sql order by first_load_time desc;
   
    alter system flush shared_pool;