Re: fine grain auditing

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_at_nyct.com> To: Nigel Thomas <nigel_cl_thomas_at_yahoo.com> 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_at_yahoo.com] 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_at_nyct.com> To: oracle-l_at_freelists.org 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

--
http://www.freelists.org/webpage/oracle-l