Home » RDBMS Server » Security » LogMiner doesn't show username
LogMiner doesn't show username [message #187065] Thu, 10 August 2006 14:03 Go to next message
kekabuk
Messages: 4
Registered: August 2006
Junior Member
Hi,

I'm trying to make some audit using Oracle LogMiner. The problem is I need the username to be shown and the query is not returning it! Someone knows why I can't see the username when I query v$logmnr_contents ??

select USERNAME, OPERATION ,SQL_REDO from v$logmnr_contents where seg_owner = 'TOMAS';

USERNAME OPERATION   SQL_REDO
-------- ---------- --------------------
         DELETE      delete from "TOMAS"
                     ."PR_PEOPLE_CAT
                     EGORY" where "EMP
                     _NO" = 'T088389' and
                     "SS_ID" = '087889' and
                     "EMP_CATEGORY" =
                     '43' and "START_DATE"
Re: LogMiner doesn't show username [message #188400 is a reply to message #187065] Fri, 18 August 2006 06:47 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Was the user created after you've enabled logminer. If so, try to enable DDL Dictionary Tracking.

EXEC DBMS_LOGMNR.start_logmnr(options=>Dbms_Logmnr.DDL_Dict_Tracking);

icon4.gif  Re: LogMiner doesn't show username [message #188414 is a reply to message #188400] Fri, 18 August 2006 08:04 Go to previous messageGo to next message
kekabuk
Messages: 4
Registered: August 2006
Junior Member
The user was created before I implemented LogMiner...
Re: LogMiner doesn't show username [message #188484 is a reply to message #188414] Fri, 18 August 2006 13:29 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Try to enable supplemental logging. That should "force" the database to capture additional info (including the username).

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS;

Re: LogMiner doesn't show username [message #188491 is a reply to message #188484] Fri, 18 August 2006 14:06 Go to previous messageGo to next message
kekabuk
Messages: 4
Registered: August 2006
Junior Member
hum... before I try this, can you tell me if supplemental logging increases too much the size of redo log files and if there is any impact to database performance, please...
Re: LogMiner doesn't show username [message #188498 is a reply to message #188491] Fri, 18 August 2006 15:08 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Good question. It depends on your implementation.

Supplemental logging will cause Oracle to log more data to the redo logs. If your application uses primary and unique keys, the overhead should be minimal. If not, Oracle will have to log all columns to the redo logs.

Why don't you test it and report back on your findings?
icon10.gif  Re: LogMiner doesn't show username [message #189910 is a reply to message #187065] Mon, 28 August 2006 07:55 Go to previous message
kekabuk
Messages: 4
Registered: August 2006
Junior Member
I've tested on my test development environment last week and I still didn't feel any diferences related with the performance, and my problem was solved! I'll just wait a few more days to start supplemental logging on my production enviroment.
Thanks for your help Frank !!
Previous Topic: granting privileges
Next Topic: problem with password verify function
Goto Forum:
  


Current Time: Sun Dec 04 17:02:06 CST 2016

Total time taken to generate the page: 0.11948 seconds