How to query database logs using PL/SQL?

In PL/SQL, you can query the database log using the following methods:

1. Utilize the DBMS_LOGMNR package, which is provided by Oracle, to query and manage database log files. You can use the ADD_LOGFILE procedure to add log files, and then use the START_LOGMNR function to begin analyzing the logs. Afterwards, you can query the log contents using the LOGMNR_CONTENTS view.

-- 添加日志文件
EXECUTE DBMS_LOGMNR.ADD_LOGFILE('path_to_redo_log_file', DBMS_LOGMNR.NEW);

-- 开始分析日志
EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);

-- 查询日志内容
SELECT *
FROM V$LOGMNR_CONTENTS;

1. The LOGMINER tool, provided by Oracle, is a standalone tool used to query and analyze database log files. It can be utilized to load log files and perform query operations.

-- 启动LOGMINER工具
EXECUTE DBMS_LOGMNR_D.BUILD(options => DBMS_LOGMNR_D.STORE_IN_REDO_LOGS);

-- 加载日志文件
EXECUTE DBMS_LOGMNR.ADD_LOGFILE('path_to_redo_log_file', DBMS_LOGMNR.NEW);

-- 开始查询
SELECT *
FROM V$LOGMNR_CONTENTS;

Please note that querying the database logs requires the appropriate permissions. Additionally, the log files must be in archive mode or have log file hanging enabled.