Monitor table usage in oracle 10g without monitoring the indeces

-- Sample 10g Fine Grain Auditing policy setup
-- mrjoltcola
-- Use the EMP schema (SCOTT/TIGER) to demonstrate fine-grained auditing (@{ORACLE_HOME}/rdbms/admin/utlsampl.sql)
 
-- 1st check database to see if either AUDITING and/or FGA support is setup
 
show parameter audit
 
/*
Should see:
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      C:\ORACLE\ADMIN\DEV\ADUMP
audit_sys_operations                 boolean     FALSE
audit_trail                          string      NONE
*/
 
-- We don't have to have standard auditing on, but to use standard auditing, set AUDIT_TRAIL above
-- Change to db_extended so we get fine grained audit plus SQL_BIND (bind vars) and SQL_TEXT auditing. Then restart database
 
sqlplus / as sysdba
 
SQL> ALTER SYSTEM SET audit_trail=db_extended SCOPE=SPFILE;
SQL> shutdown immediate
SQL> startup open
 
 
-- To use FGA, we use FGA policies
 
-- FGA
-- Add a SALARY policy to the EMP table
-- Run as SYS or another user with execute on package dbms_fga
-- Default action is to audit SELECT but with 10g we can add DML actions by adding to statement_types parameter
-- Setup a policy to audit access of Employee Salaries
begin
   dbms_fga.drop_policy (
      object_schema=>'SCOTT',
      object_name=>'EMP',
      policy_name=>'EMP_ACCESS'
  );
 
   dbms_fga.add_policy (
      object_schema=>'SCOTT',
      object_name=>'EMP',
      policy_name=>'EMP_ACCESS',
      audit_condition => NULL,  -- TRUE
      audit_column    => 'SAL',
      statement_types => 'SELECT,INSERT,UPDATE,DELETE'
);
end;
/
 
 
connect scott/tiger
 
-- Scott selects salaries and then gives self a raise
select * from emp;
update emp set sal = 30000 where ename = 'SCOTT'; 
 
 
-- DBA connects and checks audit trail
connect / as sysdba
 
-- Find who ran what against EMP table
select timestamp, db_user, sql_text from dba_fga_audit_trail where object_name = 'EMP';
 
/*
01-APR-09          SCOTT	select * from emp
 
01-APR-09          SCOTT	update emp set sal = 30000 where ename = 'SCOTT'
*/
                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71: