OraFAQ Forum: Server Administration » what's wrong with the logminer?

Home » RDBMS Server » Server Administration » what's wrong with the logminer?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

what's wrong with the logminer? [message #50938]

Mon, 15 April 2002 19:10

www
Messages: 6
Registered: April 2002

Junior Member

i use logminer to analyze my redo logfile,but i can't understand the data in the v$logmnr_contents,what's wrong with the logminer?
the script i use is as follows:
------------------------------
@dbmslogmnrd.sql
@dbmslogmnr.sql

alter session set nls_date_language='AMERICAN' ;
alter session set nls_date_format='DD-MON-YYYY HH:MI:SS' ;

EXECUTE DBMS_LOGMNR_d.BUILD('a.ora','c:');

EXECUTE dbms_logmnr.add_logfile('E:ORACLEORADATAORA8WQREDO02.LOG',DBMS_LOGMNR.NEW);
SELECT low_time,high_time,low_scn,next_scn FROM V$LOGMNR_LOGS;

execute dbms_logmnr.start_logmnr(DictFileName=>'c:a.ora')

create table logme as SELECT * FROM V$LOGMNR_CONTENTS;
select timestamp,username,sql_redo,sql_undo from logme;

the data is like this in the logme:

TIMESTAMP USERNAME
---------- --------------------------------
SQL_REDO
----------------------------------------------------------------------------------------------------
SQL_UNDO
----------------------------------------------------------------------------------------------------
' and ROWID = 'AAAABAAABAAAEUEABG';
insert into SYS.SOURCE$(OBJ#,LINE,SOURCE) values (2790,434,'-- UTL_FILE.PUT_LINE(dict_filehan
dle, column_list );
');

12-4�� -02
delete from SYS.SOURCE$ where OBJ# = 2790 and LINE = 435 and SOURCE = ' i := i +1;
' and ROWID = 'AAAABAAABAAAEUEABH';
insert into SYS.SOURCE$(OBJ#,LINE,SOURCE) values (2790,435,' i := i +1;
');

12-4�� -02
delete from SYS.SOURCE$ where OBJ# = 2790 and LINE = 436 and SOURCE = 'END LOOP;
' and ROWID = 'AAAABAAABAAAEUEABI';
insert into SYS.SOURCE$(OBJ#,LINE,SOURCE) values (2790,436,'END LOOP;

-----------------------------------------

i think the table name and column shoud like this :emp,

empno,....

Report message to a moderator

Re: what's wrong with the logminer? [message #50941 is a reply to message #50938]

Mon, 15 April 2002 20:00

seng
Messages: 191
Registered: February 2002

Senior Member

This should be system activities by database. Other way to test LogMiner is create SQL statement on an user and try to analyze the redo log or archived file, which is contented those SQL statament. Hope this is helping.

Report message to a moderator