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!
На этой странице сайта вы можете посмотреть видео онлайн Oracle LogMiner: Auditing SQL REDO/UNDO & Table Access Statistics – Step-by-Step Tutorial длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь HowToVelan 12 Октябрь 2025, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 367 раз и оно понравилось 4 зрителям. Приятного просмотра!
