查看oracle数据库最近执行了哪些sql语句

fteair

1. SELECT b.sql_text, --content of SQL
   
2.        a.machine, --which machine run this code
   
3.        a.username,
   
4.        a.module,
   
5.        -- the method to run this SQL
   
6.        c.sofar / totalwork * 100,
   
7.        --conplete percent
   
8.        c.elapsed_seconds, --run time
   
9.        c.time_remaining --remain to run time
   
10.   FROM v$session a, v$sqlarea b, v$session_longops c
    
11. WHERE a.sql_hash_value = b.hash_value(+)
    
12.    AND a.SID = c.SID(+)
    
13.    AND a.serial# = c.serial#(+)
    
14. --AND a.sid=139

复制代码

1. SELECT  *
   
2.     FROM v$sql
   
3.    WHERE last_load_time IS NOT NULL
   
4. ORDER BY last_load_time DESC

复制代码

1. ----监控concurrent 正在执行的sql --
   
2. SELECT a.sid, a.serial#, b.sql_text
   
3.   FROM v$session a, v$sqltext b
   
4. WHERE a.sql_address = b.address
   
5. ORDER BY b.piece

复制代码

张兴康

fteair

张兴康 发表于 2017-10-11 18:58

张兴康

fteair 发表于 2017-10-12 14:50

caixuqad

fteair

caixuqad 发表于 2017-10-13 14:08

caixuqad

caixuqad

fteair

caixuqad