select * from v$logfile;
select * from v$sql where first_load_time like '2021-11-17%'
select * from v$sql where first_load_time like '2021-11-17%'
where last_active_time>to_date('2021/11/27 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
and last_active_time<to_date('2021/11/27 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
and sql_text like '%update%' and sql_text like '%ka%'
order by last_active_time desc;
select * from v$sqlarea;
查看oracle数据库操作日志
最新推荐文章于 2024-08-27 19:00:35 发布