Skip Headers

Oracle9i Supplied PL/SQL Packages and Types Reference
Release 2 (9.2)

Part Number A96612-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

25
DBMS_LOGMNR

Using LogMiner, you can 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 logs 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.

See Also:

Oracle9i Database Administrator's Guide for information about using LogMiner

This chapter discusses the following topics:


Go to previous page Go to next page
Oracle
Copyright © 2000, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback