表名: 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;
表名: 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;