Audit Logs

From: Gene (gchilders_at_coredata.net)
Date: 09/03/03

  • Next message: Lintadsl: "Views on each DB" 
    Date: Wed, 3 Sep 2003 14:01:09 -0700

    We recently turned on auditing on one of our transactional
    databases. There is no problem they roll over every 200
    megs like they are supposed to. The problem comes in when
    trying to pull data out of them. For any given week of
    logs there are 400+ files. What I am needing is a way to
    search the trace files for a specific string, and opening
    them up one at a time is a real pain. If anyone knows a
    better way of searching them please let me know.

    Thanks in advance,
    Gene

  • Next message: Lintadsl: "Views on each DB"

    Relevant Pages

    • Re: Ora-3113 during execution of utlrp.sql
      ... Before bringing up any databases, does ipcs show anything owned by ... Do the trace files show any lines that say things like Exception ... What is your large pool set to? ... Have you checked metalink Note:282036.1 lately? ...
      (comp.databases.oracle.misc)
    • Re: Audit Trace Files
      ... Every time I start the server, I define a new trace file for auditing. ... Now I want to get the list of all the trace files (which are at ... As I understand it, once a trace is done, SQL Server ...
      (microsoft.public.sqlserver.security)
    • Re: Audit Trace Files
      ... In SQL Server 2005 take a look at sys.traces system table ... Every time I start the server, I define a new trace file for auditing. ... Now I want to get the list of all the trace files (which are at different ...
      (microsoft.public.sqlserver.security)
    • Quantcast