查看oracle数据库操作日志

编程开发更新时间:2023-04-01 06:03:07

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;