monitor dba_ddl_locks view
or the x$ tables that the view is based on
On 11/10/05, San Sridharan <san_oracle_dba_at_yahoo.com> wrote:
>
> For index we can monitor the index and find out if it's been used.
> Other than adding custom code to the stored procedure to track it's
> execution, is there any other way to do it without modifying it?
> Thanks,
> San
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 10 2005 - 02:02:25 CST
