Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to count record selects?
You can use Fine Grained Auditing new feature in Oracle9i. It records all
select statement on tables specified by dbms_fga.add_policy in
dba_fga_audit_trail. Also you can insert some data in custom tables through
Audit Event Handler mechanism.
HTH
santosh
"TimC" <ITSNOTCornwell_at_cs.cornell.eduUNLESSYouSaySo> wrote in message
news:atstlc$g93$1_at_news01.cit.cornell.edu...
>
> Hello all & thanks for looking,
>
> I was wondering if there's any way (for Oracle 9i2) to count the number of
> times a record is selected from the db?
>
> I have a bunch of static data tables from which records are retrieved by a
> web service, and I would like the database to handle hit counts at the db
> level so I don't have to code anything in the retrieval service.
>
> Any suggestions?
>
> TIA,
> Tim
>
>
>
>
Received on Thu Dec 19 2002 - 15:37:25 CST