dbms_logmnr
the dbms_logmnr package contains procedures used to initialize the logminer tool and to begin and end a logminer session.
this chapter contains the following topics:
dbms_logmnr
logminer allows you to make queries based on actual data values. for instance, you could issue a query to select all updates to the table scott.emp or all deletions performed by user scott. you could also perform a query to show all updates to scott.emp that increased sal more than a certain amount. such data can be used to analyze system behavior and to perform auditing tasks.
the dbms_logmnr package contains procedures used to initialize the logminer tool. you use these procedures to list the redo log files to be analyzed and to specify the scn or time range of interest. after these procedures complete, the server is ready to process sql select statements against the v$logmnr_contents view.
the data in redo log files is especially important for recovery, because you can use it to pinpoint when a database became corrupted.you can then use this information to recover the database to the state just prior to corruption.
Java Asp PHP .Net XML C/C++ CGI VB Jsp J2ee J2se J2me EJB Servlet Tomcat Resin Struts Weblogic Eclipse ANT GUI JMS Web servise IDEA Webphere Hibernate Spring Jboss Applet Swing Socket Javamail Perl Ajax P2P 安全 模式 框架 测试 开源 游戏
Windows XP Windows 2000 Windows 2003 Windows Me Windows 9.x Linux UNIX 注册表 操作系统 服务器 应用服务器