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: DA Morgan <damorgan_at_exesolutions.com>
Date: Thu, 19 Dec 2002 10:47:19 -0800
Message-ID: <3E021437.8D4A4666@exesolutions.com>


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

Original text of this message

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