Re: 9i v$object_usage feature in 8.1.7

In article <3c782257.116458338_at_netnews.attbi.com>, marlythomas_at_hotmail.com says...
>
>Well, thanks anyway.
>
>I didn't imply simply creating the table and view would do the trick -
>rather was wondering if anyone had tried to build a monitoring proc to
>emulate the 9i functionality.
>
>You are correct in saying indexes don't show up in normal auditing.
>I'm working on a trigger mechanism now that would explain the sql
>after a select hit and note the indexes used.
>
>Marly

see query plan stability, it'll save all of the hints needed to make a query run the same way using the same plan later. In the hints are the indexes used.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp