Oracle-L: Logminer

From: John Dunn <john.dunn_at_sefas.co.uk>
Date: Tue, 19 Mar 2002 05:08:20 -0800
Message-ID: <F001.0042CE32.20020319050820@fatcity.com>

Logminer shows a large number of entries in redo logs for SYS as follows :

What generates these?

select timestamp,username, sql_redo from v$logmnr_contents

03-19-2002:12:31:24 SYS 03-19-2002:12:31:24 SYS
commit;

03-19-2002:12:31:27 SYS
set transaction read write;

John

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: John Dunn
INET: john.dunn_at_sefas.co.uk

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 Tue Mar 19 2002 - 07:08:20 CST

Logminer - again