Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to count record selects?

Re: How to count record selects?

From: santosh <santy_at_yahoo.com>
Date: Thu, 19 Dec 2002 13:37:25 -0800
Message-ID: <atte1o$2f376$1@ID-84096.news.dfncis.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US