Re: fine grain auditing
- From: Nigel Thomas <nigel_cl_thomas@xxxxxxxxx>
- To: "Steiner, Randy" <Randy.Steiner@xxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 11 Sep 2007 11:37:18 -0700 (PDT)
I don't know, never having used FGA. Try altering the table to set DEGREE = 0
and/or include /*+ noparallel */ hint in your SQL. Do you now get just one
entry in FGA? If so, that's probably the issue. Now you may need to consider
a) whether the size matters
b) whether you need to aggregate the accesses
c) whether to do that with an FGA event handler (RTFM ...)
Regards Nigel
----- Original Message ----
From: "Steiner, Randy" <Randy.Steiner@xxxxxxxx>
To: Nigel Thomas <nigel_cl_thomas@xxxxxxxxx>
Sent: Tuesday, September 11, 2007 7:12:58 PM
Subject: RE: fine grain auditing
I am parallel execution on the table. But most of the tables I plan to audit
will have parallel query enabled.
Does that mean my audit table will be huge?
From: Nigel Thomas [mailto:nigel_cl_thomas@xxxxxxxxx]
Sent: Tuesday, September 11, 2007 2:10 PM
To: Steiner, Randy
Subject: Re: fine grain auditing
Wild guess (hence not copied to list): are you seeing FGA logged from some
parallel slaves perhaps? what is the degree of parallelism on test_table?
----- Original Message ----
From: "Steiner, Randy" <Randy.Steiner@xxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Tuesday, September 11, 2007 6:14:38 PM
Subject: fine grain auditing
Hi,
I turned fga on for a test table. I do select * from test_table where rownum <
11;
In dba_fga_audit_trail I see 9 entries with the exact time and sql. Each line
has a different OS_PROCESS entry.
I thought there should only be 1 entry for each sql statement executed, but I
am getting multiple.
Does anyone know why?
Thanks
Randy
Other related posts:
