Files
Knowledge/1 使用/数据库/达梦数据库查看最近sql.md

26 lines
260 B
Markdown
Raw Permalink Blame History

This file contains invisible Unicode characters
This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
表名:  V$SQL_HISTORY  
select
SQL_ID,
SESS_ID,
SESS_SEQ,
TRX_ID,
TOP_SQL_TEXT,  -- 执行SQL内容
START_TIME,  --  执行SQL开始时间
TIME_USED,  --  SQL执行时长
N_LOGIC_READ,
N_PHY_READ,
HARD_PARSE_FLAG 
FROM
V$SQL_HISTORY;