Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to count record selects?
TimC wrote:
> 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
No.
Unless you want to run all of your queries through a procedure that does the logging. And that would require a high degree of masochism and would kill scalability and performance.
Dan Morgan Received on Thu Dec 19 2002 - 12:47:19 CST