Oracle LogMiner, a utility provided by Oracle Corporation to purchasers of its Oracle database, 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 s ...

, 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 Enterpri ...

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, database design, migration, performance monitoring, security, troubleshooting, as well as ba ...

s can use LogMiner to: * identify the time of a database-event * isolate transactions 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 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 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