Hi,
I had sent this some time back but got no answer for version 8.1.7. For table I understand auditing is an option. What about for index? Thank You
A Joshi <[EMAIL PROTECTED]> wrote:
A Joshi <[EMAIL PROTECTED]> wrote:
Hi,Is there an easy way to find out if a table or an index is being used. I mean short of going thru all code or keeping looking at v$sqlarea. I mean even if code is covered there are always ad hoc SQL queries etc. Same for other objects like views etc. Is there a place where oracle stores objects accessed and any other related info.Thanks
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
