Can you define "number of hits"? Are we talking selects? Or DML
(inserts, updates, deletes)?

Do you really want the information at the column level? Folks are
generally interested in IO at the row/segment/extent level...

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Shobit Sati
[mailto:oracledba-ezmlmshield-x10760657.[Email address protected]
Sent: Monday, October 31, 2005 10:45 AM
To: LazyDBA Discussion
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