LogMiner_Automatically
来源:互联网 发布:淘宝开店代销怎么赚钱 编辑:程序博客网 时间:2024/06/05 16:14
#!/bin/bash
sqlplus / as sysdba << EOF
spool spool.log
execute dbms_logmnr_d.build(dictionary_filename => 'logminer_dict.dat',dictionary_location => '/u01/log');
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select sysdate from dual;
EXECUTE DBMS_LOGMNR.START_LOGMNR(STARTTIME => '2014-10-05 18:09:23', ENDTIME => '2014-10-05 18:14:23',OPTIONS => DBMS_LOGMNR.CONTINUOUS_MINE);
select filename from v\$logmnr_logs;
execute dbms_logmnr.start_logmnr(dictfilename => '/u01/log/logminer_dict.dat');
SELECT sql_redo FROM v\$logmnr_contents where username='EISOO';
sqlplus / as sysdba << EOF
spool spool.log
execute dbms_logmnr_d.build(dictionary_filename => 'logminer_dict.dat',dictionary_location => '/u01/log');
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select sysdate from dual;
EXECUTE DBMS_LOGMNR.START_LOGMNR(STARTTIME => '2014-10-05 18:09:23', ENDTIME => '2014-10-05 18:14:23',OPTIONS => DBMS_LOGMNR.CONTINUOUS_MINE);
select filename from v\$logmnr_logs;
execute dbms_logmnr.start_logmnr(dictfilename => '/u01/log/logminer_dict.dat');
SELECT sql_redo FROM v\$logmnr_contents where username='EISOO';
EXECUTE DBMS_LOGMNR.END_LOGMNR;
spool off
quit
EOF
0 0
- LogMiner_Automatically
- android studio 报错Error:(6, 24) 警告:编码 GBK 的不可映射字符
- python os模块总结 .
- VS2010 / MFC + OpenCV 2.4.1打开图片
- API创建员工Element
- 黑马程序员--懒汉式和饿汉式单例设计模式
- LogMiner_Automatically
- 剑指offer————(面试题50)获取任意节点的公共父节点
- Python 正则表达式提取URL中的Scheme
- DHTML(table,row,cell)
- 算法题1+2+...+N
- web.xml 详细介绍
- Messenger和MVVM中的View Services
- 简单的页面打字效果
- API创建员工支付方式