Logminer简单用法
来源:互联网 发布:windows server 2003 编辑:程序博客网 时间:2024/06/05 00:15
Logminer简单用法
1. 安装Logminer
SQL>@?/rdbms/admin/dbmslm.sqlSQL>@?/rdbms/admin/dbmslmd.sqlSQL>@?/rdbms/admin/dbmslms.sql
2. 创建数据字典
SQL> alter system set utl_file_dir='/oradata/lgmnr' scope=spfile;--restart the instance-- Create a dictionary file -- (init.ora parameter utl_file_dir must be set)exec dbms_logmnr_d.build('mydictfile', '/oradata/lgmnr');
3. 添加日志
-- Register log files, can be from a different db-- (NEWFILE=start new list/ ADDFILE=add next file)exec dbms_logmnr.add_logfile('/arch/1_141_810359695.dbf', dbms_logmnr.new); exec dbms_logmnr.add_logfile('/arch/1_142_810359695.dbf', dbms_logmnr.addfile); exec dbms_logmnr.add_logfile('/arch/1_143_810359695.dbf', dbms_logmnr.addfile);
4. 使用字典分析日志
-- Start the logminer sessionexec dbms_logmnr.start_logmnr(DictFileName => '/oradata/lgmnr/mydictfile');
5. 查看日志
-- Query v_$logmnr_contents view to extract required infoselect timestamp, sql_undofrom sys.v_$logmnr_contentswhere seg_name = 'T';select operation,sql_redo,sql_undo from v$logmnr_contents where seg_owner='BBED' and seg_name='T' and rownum<=10;
6. 结束日志挖掘
-- Query v_$logmnr_contents view to extract required infoselect timestamp, sql_undofrom sys.v_$logmnr_contentswhere seg_name = 'T';select operation,sql_redo,sql_undo from v$logmnr_contents where seg_owner='BBED' and seg_name='T' and rownum<=10;
- Logminer简单用法
- Oracle Logminer 简单使用
- 使用LogMiner 的简单步骤
- 使用LogMiner的简单步骤
- Logminer
- LogMiner
- LogMiner
- logminer
- LogMiner
- logminer
- logminer
- Logminer
- LogMiner
- LogMiner
- LogMiner
- LogMiner
- logminer
- oracle工具:logminer的简单使用
- HTTP协议详解
- ubuntu 12.04上面安装java jdk
- SAEJ1939,第四波
- java中使用schema验证xml文档
- Android设计模式系列(1)--SDK源码之组合模式
- Logminer简单用法
- 马士兵JAVA学习路线图(一) 入门篇
- view组件draw,onDraw,dispatchDraw
- DirectX 基础 (DirectShow 开发指南笔记)
- WIZZARD制作
- 单向辛克天线matlab程序
- Android SDK Manager下载和更新失败方法详解
- ognl表达式
- python egg包的制作与安装