选择显示字体大小

logminer enhancements in oracle9i


　　the basic usage of logminer is the same between oracle8i and oracle9i so for basic usage notes see the logminer article in the oracle8i section.

several new features have been added to logminer in oracle9i to make it more flexible and robust:

ddl statements

in previous versions of logminer ddl statements were viewed as a list of dml statements against the internal tables. in oracle9i the actual ddl statement is now logged. the v$logmnr_contents view now contains a column called operation which indicates if the operation was ddl or dml. the sql_redo column shows the actual ddl command.

data dictionary access

the dictionary is used by logminer to translate object ids into meaningful object names. in oracle8i this had to be stored as a flat file on the file system. in oracle9i you can choose to store the dictionary in the redo logs:
execute dbms_logmnr_d.build( -
dictfilename => 'c:\oracle\oradata\tsh1\archive\dictionary.ora', options => dbms_logmnr_d.store_in_flat_file);

execute dbms_logmnr_d.build( -
options => dbms_logmnr_d.store_in_redo_logs);
the latter option can only be used if the database is in archivelog mode and will cause a considerable increase in redo.

logminer can be started using a dictionary file, redo logs or the online dictionary:
execute dbms_logmnr.start_logmnr( -
dictfilename =>'c:\oracle\oradata\tsh1\archive\dictionary.ora');

execute dbms_logmnr.start_logmnr( -
options => dbms_logmnr.dict_from_redo_logs);

execute dbms_logmnr.start_logmnr( -
options => dbms_logmnr.dict_from_online_catalog);
if objects have been dropped and recreated the online dictionary may not be able to resolve some object ids. its main use is for recent redo logs.

ddl dictionary tracking

in oracle8i the dictionary file was static. any objects created after the creation of the dictionary file could not be translated. in oracle9i the ddl_dict_tracking option makes logminer apply any ddl operations to its dictionary allowing the translation of new objects.
execute dbms_logmnr.start_logmnr( -
options => dbms_logmnr.ddl_dict_tracking);
the database must be open for this option.

dictionary staleness

in oracle9i versioning information is logged about each object. if a ddl statement is issued against an object this will alter its version. logminer is aware of this versioning information and can detect if the current dictionary is not in sync with redo logs.

log corruption

prior to oracle9i corruption of the logfiles caused logminer to stop. in oracle9i the skip_corruption option in the dbms_logmnr.start_logmnr() procedures tells logminer to attempt to pass over corruptions:
execute dbms_logmnr.start_logmnr( -
options => dbms_logmnr.skip_corruption);
logminer indicates the number of blocks skipped.

committed data only

the committed_data_only option means that logminer will only display sql_redo and sql_undo for commited transactions, greatly reducing the number of rows displayed:
execute dbms_logmnr.start_logmnr( -
options => dbms_logmnr.committed_data_only);

primary keys

by default sql_redo and sql_undo statements contain rowid references in the where clause. if this data is to used against a different database this rowid has no meaning. for this reason logminer can be configured to display the primary key value, which can be used in place of the rowid. the rowid is still displayed.

to get these results supplemental redo log groups must be added at the table or database level. this feature significantly increases the amount of redo at the database level.

restrictions

logminer does not support:
logminor cannot be run in a multithreaded server (mts) environment but it can be used to analyze logs from a an mts environment.

logminer can now be used to view direct path loads as long as the system is in archivelog mode and logging is enabled.

logminer views & viewer

very few changes have occurred to the dictionary views. the v$logmnr_contents view now contains a column called operation which indicates if the operation was ddl or dml. the v$logmnr_dictionary view only contains rows if the store_in_flat_file option was used to create the dictionary.

oracle enterprise manager now includes a gui tool called logminor viewer which allows you to build and store queries against the v$logmnr_contents view. rows can be returned with the primary key values displayed and the view can be restricted to commited transactions if required.

hope this helps. regards tim...

back to the top.


 


关键字 本文所属关键字

相关 与本文相关文章

分类 所有文章关键字导航

源码编程相关

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   安全   模式   框架   测试   开源   游戏

SQL数据库相关

My-SQL   Ms-SQL   Access   DB2   Oracle   Sybase   SQLserver   索引   存储过程   加密   数据库   分页   视图  

手机无线相关

3G   Wap   CDMA   GRPS   GSM   IVR   彩信   短信   无线   增值业务

网页设计制作相关

HTML   CSS   网页配色   网页特效   Javascript   VBscript   Dreamweaver   Frontpage   JS   Web   网站设计

网站建设推广相关

建站经验   网站优化   网站排名   推广   Alexa

操作系统/服务器相关

Windows XP   Windows 2000   Windows 2003   Windows Me   Windows 9.x   Linux   UNIX   注册表   操作系统   服务器   应用服务器

图形图像多媒体相关

Photoshop   Fireworks   Flash   Coreldraw   Illustrator   Freehand   Photoimpact   多媒体   图形图像

标准 网站致力的规范

Valid CSS!

无不良内容，无不良广告，无恶意代码

Valid XHTML 1.0 Transitional

creativecommons