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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
