Re: Logminer - again

From: Lyubomir Petrov <lpetrov_at_yahoo.com>
Date: Tue, 19 Mar 2002 10:03:24 -0800
Message-ID: <F001.0042D68C.20020319100324@fatcity.com>

Most of the transactions in the redo log are written in this way:

SQL_REDO

---

set transaction read write;
insert/update/delete something
commit;

'set transaction read write' is the default setting for a transaction and that's why it's there, I quess. Commit is self explaining.

The statements with username = 'SYS' are either you doing something as SYS or recursive SQL.

Lyubomir Petrov

• John Dunn <john.dunn_at_sefas.co.uk> wrote:
  > 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).
  

  ---

Do You Yahoo!?
Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lyubomir Petrov
  INET: lpetrov_at_yahoo.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 Tue Mar 19 2002 - 12:03:24 CST