Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to?
David, all you can get is whats in v$logmnr_contents.
so if session_info has anything worthwhile, you'd be good, otherwise out of luck, machine is not a field in v$logmnr_contents, its only part of v$session.
joe
Nguyen, David M wrote:
>Ramon,
>
>I know how to setup LogMiner to run. My question is if LogMiner can tell me
>where an user is logging in from what computer?
>
>Thanks,
>David
>
>-----Original Message-----
>Sent: Thursday, July 11, 2002 4:15 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Nguyen,
>
>1) Be sure to have set the parameter UTL_FILE_DIR='d:\directorio'
>2) Create the dictonary file
> Execute the package DBMS_LOGMNR_D.BUILD('dictionary', 'd:\directorio');
>3) Reset the list and create a new one
> Execute the package DBMS_LOGMNR.ADD_LOGFILE('redo01.log',
>dbms_logmnr.new);
>4) Add more redos to analyze
> Execute the package DBMS_LOGMNR.ADD_LOGFILE('redo01.log',
>dbms_logmnr.addfile);
>5) Perform the analysis
> Execute
>DBMS_LOGMNR.START_LOGMNR(dictionary=>'d:\directorio\dictionary');
>6) Do a select from the V$LOGMNR_CONTENTS
>
>HTH
>
>Ramon
>
>
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Thursday, July 11, 2002 12:48 PM
>
>
>
>
>>Using LogMiner to read redo log, how do I tell a transaction is modified
>>
>>
>by
>
>
>>which user and where user logins from like what columns in LogMiner should
>>tell me this kind of information?
>>
>>Thanks,
>>David
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Nguyen, David M
>> INET: david.m.nguyen_at_xo.com
>>
>>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>>San Diego, California -- Public Internet access / Mailing Lists
>>--------------------------------------------------------------------
>>To REMOVE yourself from this mailing list, send an E-Mail message
>>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>>the message BODY, include a line containing: UNSUB ORACLE-L
>>(or the name of mailing list you want to be removed from). You may
>>also send the HELP command for other information (like subscribing).
>>
>>
>
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: jtesta_at_dmc-it.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Jul 11 2002 - 19:48:29 CDT