** table or procedure last accessed

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Mon, 8 Nov 2004 13:03:17 -0800 (PST)
Message-ID: <20041108210317.4466.qmail@web60710.mail.yahoo.com>

Hi,
  Is there a way to know when an object i.e. table, index, package, procedure was accessed. select table or execute procedure or index used. If there is no direct way then I think I can do audit for table. Any similar option for index or procedure.  

Thanks for your help.                         

---

Do you Yahoo!?
 Check out the new Yahoo! Front Page. www.yahoo.com

--

http://www.freelists.org/webpage/oracle-l Received on Mon Nov 08 2004 - 15:05:23 CST