Misplaced Pages

Oracle LogMiner

Article snapshot taken from Wikipedia with creative commons attribution-sharealike license. Give it a read and then ask your questions in the chat. We can research this topic together.
Software product
This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these messages)
This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.
Find sources: "Oracle LogMiner" – news · newspapers · books · scholar · JSTOR (January 2014) (Learn how and when to remove this message)
The topic of this article may not meet Misplaced Pages's general notability guideline. Please help to demonstrate the notability of the topic by citing reliable secondary sources that are independent of the topic and provide significant coverage of it beyond a mere trivial mention. If notability cannot be shown, the article is likely to be merged, redirected, or deleted.
Find sources: "Oracle LogMiner" – news · newspapers · books · scholar · JSTOR (January 2014) (Learn how and when to remove this message)
(Learn how and when to remove this message)

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, principally through SQL commands referencing data in Oracle redo logs. A GUI interface for the functionality comes with the Oracle Enterprise Manager product.

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

Database administrators 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 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.

See also

External links


Stub icon

This database software-related article is a stub. You can help Misplaced Pages by expanding it.

Categories: