RE: How to count record selects?

"Robert Rainville" <[email protected]>
Newsgroups gmane.comp.db.oracle.devel
Message-ID <LYRIS-1796914-807088-2002.12.19-15.12.22--gcdod-oracle#[email protected]>
You could probably use auditing
But this will put a lot of overhead on your Database

-----Original Message-----
From: Tim C. [mailto:[email protected]] 
Sent: Thursday, December 19, 2002 9:24 AM
To: Oracle
Subject: [oracle] How to count record selects?

Hello all & thanks for looking,

I was wondering if there's any way (for Oracle 9i2) to count the nubmer
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
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to %%email.unsub%%.

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.