Re: Logminer Question

Ed, in the 8i world, there is more than you want to know amount of redo/undo that goes on where the username is not available. The format of the redo logs(or oracle intentionally left out) leaves a bit to be desired in the version of lognminer for 8i.

9i its a whole lot better.

some of the reasons are data dictionary allocation and deallocation of extents as well as any rows that are migrated and /or chained will not give you much to look at it the logs.

hth, joe

Ed Bittel wrote:
>
> I'm analyzing archive logs from an 8.1.6.3 database
> running on Solaris. There are many entries in
> v$logmnr_contents with a NULL username and DATA_OBJ#
> and DATA_OBJD# values that don't match anything I can
> find in sys.obj$. What would account for these
> entries in v$logmnr_contents?
>
> Example
> =======
> SELECT username, OPERATION, count(*)
> FROM v$logmnr_contents group by username, operation
> /
>
> USERNAME OPERATION COUNT(*)
> -------------- ---------------- ----------
> WANT_NUTS COMMIT 301
> WANT_NUTS DELETE 4
> WANT_NUTS INSERT 4
> WANT_NUTS INTERNAL 884
> WANT_NUTS START 301
> WANT_NUTS UPDATE 296
> ZEDWARDS COMMIT 3
> ZEDWARDS INSERT 446
> ZEDWARDS INTERNAL 15
> ZEDWARDS START 4
> OKSERVER1 COMMIT 20
> OKSERVER1 DELETE 30
> OKSERVER1 INSERT 296
> OKSERVER1 INTERNAL 269
> OKSERVER1 START 20
> OKSERVER1 UPDATE 163
> SYS COMMIT 4034
> SYS DELETE 291
> SYS INSERT 71
> SYS INTERNAL 6997
> SYS START 4036
> SYS UPDATE 4346
> COMMIT 7
> DELETE 1235
> INSERT 2242
> INTERNAL 843
> START 2
> UNSUPPORTED 266
> UPDATE 59002
>
> 37 rows selected.
>
> FYI, data from this database is being replicated via
> snapshot to a reporting database. Could that be
> responsible for the NULL username entries?
>
> Solaris 7 & Oracle 8.1.6.3
>
> __________________________________________________
> Do You Yahoo!?
> Find the one for you at Yahoo! Personals
> http://personals.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ed Bittel
> INET: bitlist_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)

-- 
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: teci_at_the-testas.net

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