SELECT
    s.inst_id,
    s.sid,
    s.serial#,
    s.username,
    s.osuser,
    s.machine,
    s.program,
    TO_CHAR(s.logon_time, 'YYYY-MM-DD HH24:MI:SS') AS logon_time,
    s.status,
    s.sql_id,
    t.sql_text,
    ROUND((SYSDATE - s.logon_time) * 24 * 60, 2) AS minutes_connected
FROM
    gv$session s
LEFT JOIN
    (SELECT
        sql_id,
        inst_id,
        LISTAGG(sql_text, ' ') WITHIN GROUP (ORDER BY piece) AS sql_text
    FROM
        gv$sqltext_with_newlines
    GROUP BY
        sql_id, inst_id
    ) t
ON
    s.sql_id = t.sql_id AND s.inst_id = t.inst_id
WHERE
    s.type = 'USER'
ORDER BY
    logon_time;
复制