![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
shuping860126
心有多大舞台就有多大
展开
-
查看Oracle redo日志来分析SQL执行记录
1)设置Oracle数据字典导出路径参数(可选) shutdown immediatealter system set UTL_FILE_DIR='/opt/oracle/utl' scope=spfile; execute dbms_logmnr_d.build(dictionary_filename => 'logminer_dict.ora', dictionary_loca...原创 2016-08-04 14:06:59 · 3433 阅读 · 0 评论 -
Oracle 日志查看
Oracle日志查看一.Oracle日志的路径:登录:sqlplus "/as sysdba"查看路径:SQL> select * from v$logfile;SQL> select * from v$logfile;(#日志文件路径)二.Oracle日志文件包含哪些内容:(日志的数量可能略有不同)control01.ctl example01.dbf redo02.log sysa...原创 2016-08-05 16:04:19 · 440 阅读 · 0 评论