Re: Running LOGMINER - DBA OK/Involvment required ?

On Tue, 18 Jun 2002 12:06:31 -0400, "R Chin" <rchin_at_panix.com> wrote:

>
>As a developer I am wondering, regarding running LOGMNR
>to investigate "who did it" things....I'd like some comments from your
>experience.
>In general.....
>1) Is this very resource-intensive ?
>2) Is this something that requires DBA approval ?
>3) if no approval required....should DBA be notified before hand ?
>
>
>In order to exmine production logs on dev box,
>1)I have to generate dictionary file on prod
>2) Copy the archive log from production and run logmnr there
>...right ?
>
>Thanks for your comments
>
>Rob
>8.1.7.2-AIX
>
>

Question: do you think everyone should be capable to read Exchange log files/messages. Usually the system administrator can. Do you think a random developer should have that privilege? Definitely not. Don't you think setting up your own logging facility within the application will be far more efficient than wading through 1000s and 1000s of transactions? I do. Just adding three columns to all your tables and adding some triggers will do the tric. Why wade through 1000s of transactions?
Also investigating the redo logs on a production instance would IMHO constitute a security breach.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jun 18 2002 - 12:26:17 CDT