Oracle LogMiner, a utility provided by

Oracle Corporation Oracle Corporation is an American multinational computer technology corporation headquartered in Austin, Texas. In 2020, Oracle was the third-largest software company in the world by revenue and market capitalization. The company sells da ...

to purchasers of its

Oracle database Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online ...

, provides methods of querying logged changes made to an Oracle

database In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases spa ...

, principally through SQL commands referencing data in Oracle

redo log Undo is an interaction technique which is implemented in many computer programs. It erases the last change done to the document, reverting it to an older state. In some more advanced programs, such as graphic processing, undo will negate the las ...

s. A

GUI The GUI ( "UI" by itself is still usually pronounced . or ), graphical user interface, is a form of user interface that allows users to interact with electronic devices through graphical icons and audio indicator such as primary notation, inste ...

interface for the functionality comes with the

Oracle Enterprise Manager Oracle Enterprise Manager (OEM) is a set of web-based tools aimed at managing software and hardware produced by Oracle Corporation as well as by some non-Oracle entities. Releases Oracle Enterprise Manager includes three releases: Oracle Enterpris ...

product. LogMiner turns the concept and practices of data mining on the internal processes of the database itself.

Database administrator Database administrators (DBAs) use specialized software to store and organize data. The role may include capacity planning, installation, configuration Configuration or configurations may refer to: Computing * Computer configuration or system c ...

s can use LogMiner to: * identify the time of a database-event * isolate

transaction Transaction or transactional may refer to: Commerce *Financial transaction, an agreement, communication, or movement carried out between a buyer and a seller to exchange an asset for payment *Debits and credits in a Double-entry bookkeeping syst ...

s carried out in error by users * determine steps needed for the

recovery Recovery or Recover may refer to: Arts and entertainment Books * ''Recovery'' (novel), a Star Wars e-book * Recovery Version, a translation of the Bible with footnotes published by Living Stream Ministry Film and television * ''Recovery'' (fil ...

of inadvertent changes to data * assemble data on actual usage for use in performance-tuning and capacity-planning *

audit An audit is an "independent examination of financial information of any entity, whether profit oriented or not, irrespective of its size or legal form when such an examination is conducted with a view to express an opinion thereon.” Auditing ...

the operation of any commands run against the database Note that LogMiner uses Oracle logs to reconstruct exactly how data changed, whereas the complementary utility

Oracle Flashback In Oracle databases, Flashback tools allow administrators and users to view and manipulate past states of an instance's data without (destructively) recovering to a fixed point in time. Compare the functionality of Oracle LogMiner, which identi ...

addresses, reconstructs and presents the finished results of such changes, giving a view of the database at some point in time.

External links

Supporting Oracle
(German) Documents on how to use LogMiner, Auditing and more Oracle software {{database-software-stub

See also

External links