ords日志对应sql

[[sql]] [[ords]] 来源
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27



SELECT s.ECID
     , s.SID
     , s.ACTION
     , s.MODULE
     , s.TERMINAL
     , s.client_info
     , s.PLSQL_SUBPROGRAM_ID
     , s.PROGRAM
     , (SELECT MAX(SUBSTR(sql_text, 1, 40)) FROM v$sql sq WHERE sq.sql_id = s.sql_id)                                                    AS sql_text
     , (SELECT object_name
        FROM dba_procedures
        WHERE object_id = plsql_entry_object_id
          AND subprogram_id = 0)                                                                                                         AS plsql_entry_object
     , (SELECT procedure_name
        FROM dba_procedures
        WHERE object_id = plsql_entry_object_id
          AND subprogram_id = plsql_entry_subprogram_id)                                                                                 AS plsql_entry_subprogram
     , (SELECT object_name
        FROM dba_procedures
        WHERE object_id = plsql_object_id AND subprogram_id = 0)                                                                         AS plsql_entry_object
     , (SELECT procedure_name
        FROM dba_procedures
        WHERE object_id = plsql_object_id
          AND subprogram_id = PLSQL_SUBPROGRAM_ID)                                                                                       AS plsql_entry_subprogram
FROM v$session s
WHERE s.ecid = 'Xt4HuSJqD2nUM61ACIlwzA';