Топ-100
 
CerebroSQL

Logminer - user interface

Working with a window

 

Logminer is an Oracle DBMS archived log mining engine.

Main window -> DB -> Logminer UI

Oracle LogminerUI

 

Sequencing:

  • Enter the path to the folder with the archived logs in the "Archivelog directory" field. 

Expanding the list selects information from v$parameter , non-empty parameter values  log_archive_dest_%

  • Press the "Get list file" button to get a list of files in the directory

  • In the list "The list of files in the directory" select the necessary logs to view the data

  • "View data" button is pressed to load log data

Button "Stop logmnr" - close the dataset

Button "Reopen query" - reopen the dataset

Tab "Query" - query to view log data

Tab "Script" - the full text of the script for viewing logs

Oracle logminerUI view data

 

Getting a list of files in a directory

DECLARE
 pattern VARCHAR2(1024) := $$FOLDER_PATH;
 ns VARCHAR2(1024);
BEGIN
 DBMS_OUTPUT.ENABLE(1000000);
 SYS.DBMS_BACKUP_RESTORE.searchFiles(pattern, ns);
 FOR each_file IN (SELECT FNAME_KRBMSFT AS name FROM X$KRBMSFT) LOOP
     DBMS_OUTPUT.PUT_LINE(each_file.name);
 END LOOP;
END;   

Extracting data from logs

begin DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '$$FILE_PATH',OPTIONS => DBMS_LOGMNR.ADDFILE); end;

/

begin DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG); end;

/

select * FROM v$logmnr_contents l;