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!
Nesta página do site você pode assistir ao vídeo on-line Oracle LogMiner: Auditing SQL REDO/UNDO & Table Access Statistics – Step-by-Step Tutorial duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário HowToVelan 12 Outubro 2025, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 367 vezes e gostou 4 espectadores. Boa visualização!
