-
编辑 删除
Java执行exe,bat等可执行文件
Process proc = Runtime.getRuntime().exec(command);[@more@]import java.io.BufferedReader;import java.io.IOException;import java.io.InputStreamReader;public class CallExe { public static void main(String[] args) { String text = null; String command = "C:Program FilesYodaoDeskDictRunDict.exe";//exe,bat文件名OR DOS命令 try { Process proc = Runtime.getRuntime().exec(command); BufferedReader in = new BufferedReader(new InputStreamReader(proc.getInputStream())); while ((text = in.r
-
编辑 删除
查找v$logmnr_contents表没有找到insert,update 操作的记录
使用logmnr分析日志，查找v$logmnr_contents表，发现不到对表的insert ,update记录，后来才知道原来是Supplemental logging is turned off。 [@more@]SQL> select supplemental_log_data_pk, supplemental_log_data_ui from v$database;SUPPLEMENTAL_LOG_DATA_PK SUPPLEMENTAL_LOG_DATA_UI------------------------ ------------------------NO NO对数据库作如下修改：SQL> alter database add supplemental log data (primary key, unique index) columns;Database alteredSQL> select supplemental_log_data_pk, supplemental_
-
编辑 删除
logminer配置
oracle logminer配置[@more@]Conn as sysdba 需要以管理员身份连接,或者用户已授予了EXECUTE_CATALOG_ROLE权限1.创建DBMS_LOGMNR包SQL>@$ORACLE_HOME/rdbms/admin/dbmslm.sql2.创建相关数据字典SQL>@$ORACLE_HOME/rdbms/admin/dbmslmd.sql3.修改初始化参数UTL_FILE_DIR,指定分析数据的存放处SQL>alter system set UTL_FILE_DIR='d:/orcale/logs'scope=spfile;或者修改init.ora初始化参数文件,增加UTL_FILE_DIR=d:orcalelogs4.重启数据库SQL>shutdown immediateSQL>startup5.创建数据字典文件 先创建目录d:/oracle/logs然后
