I think your best bet will be to write a trigger to do that for you.
Sabina.




"Shobit Sati " <oracledba-ezmlmshield-x10760657.[Email address protected]
10/31/2005 10:44 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
No. of Hits on a Column of a table ...






Hi,

Can some one please give me an idea to find out no. of hits a column in
a table is getting from various quires running on the database, is their
any stats like that provided by oracle.

Thanks,
Shobhit

________________________________________________________________________

This e-mail message (including any attachment) is intended only for the
personal
use of the recipient(s) named above. This message is confidential and may
be
legally privileged. If you are not an intended recipient, you may not
review, copy or
distribute this message. If you have received this communication in error,
please notify
us immediately by e-mail and delete the original message.

Any views or opinions expressed in this message are those of the author
only.
Furthermore, this message (including any attachment) does not create any
legally
binding rights or obligations whatsoever, which may only be created by the
exchange
of hard copy documents signed by a duly authorised representative of
Hutchison
3G UK Limited..
________________________________________________________________________



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html



Oracle LazyDBA home page