Oracle LogMiner: Auditing SQL REDO/UNDO & Table Access Statistics – Step-by-Step Tutorial
Blog: https://tinyurl.com/orcllgmn
Unlock powerful auditing in Oracle databases with LogMiner!
In this detailed video, you'll learn how to use LogMiner to mine SQL REDO and UNDO, audit DML operations, and calculate table access statistics.
We cover everything you need to know for a successful LogMiner session, including:
Enabling supplemental logging at the database level
Handling archive log mode and dictionary requirements
Mining redo and archived redo logs
Configuring and querying vital Oracle views (V$LOGMNR_LOGS, V$LOGMNR_CONTENTS)
Performing committed and rolled-back transaction audits
Step-by-step walkthroughs for test routines and audit scenarios
Pro tips for advanced supplemental logging and continuous mining
Whether you’re an Oracle DBA or learning to audit transactional activity, this demo shows real-world commands, setup, troubleshooting, and best practices for effective database auditing.
Resources mentioned:
Oracle LogMiner Documentation
Example SQL and PL/SQL routines
Subscribe for more real-world Oracle DBA tutorials!
On this page of the site you can watch the video online Oracle LogMiner: Auditing SQL REDO/UNDO & Table Access Statistics – Step-by-Step Tutorial with a duration of hours minute second in good quality, which was uploaded by the user HowToVelan 12 October 2025, share the link with friends and acquaintances, this video has already been watched 367 times on youtube and it was liked by 4 viewers. Enjoy your viewing!
