RE: How to?

David,
Have a look at the session_info column in v$logmnr_contents

This includes machine, terminal, osuser + OS program

Whether this will tell you what user logs in from which computer will dependeg  do your users share usernames, do they have generic OS logins, do you have an app server, and so on

HTH,
Bruce Reardon

-----Original Message-----
Sent: Friday, 12 July 2002 9:58

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

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 -----
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: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

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).