sql_id로 쿼리 찾는 방법

OS환경 : Oracle Linux 6.8 (64bit)

 

DB 환경 : Oracle Database 11.2.0.4

 

방법 : 

sql_id 로 쿼리 찾기

SQL> 
SELECT SQL_ID, LAST_LOAD_TIME, SQL_FULLTEXT FROM V$SQL
WHERE SQL_ID = '459f3z9u4fb3u'
ORDER BY LAST_LOAD_TIME;
 
SQL_ID          LAST_LOAD_TIME                 SQL_FULLTEXT
------------- -------------------------------------- --------------------------------------------------------------------------------
459f3z9u4fb3u 2021-10-17/06:39:22             select value$ from props$ where name = 'GLOBAL_DB_NAME'

 

 

내가 실행한 SQL의 SQL_ID 찾기

SQL> 
SELECT 
  B.PREV_SQL_ID, (
    SELECT 
      SQL_TEXT 
    FROM 
      V$SQL A 
    WHERE 
      A.SQL_ID = B.PREV_SQL_ID 
      AND ROWNUM = 1
  ) AS SQL_TEXT 
FROM V$SESSION B
WHERE B.SID = USERENV('SID');

 

 

참조 : http://lvsin.tistory.com/482
http://www.koreaoug.org/administration/1637