Home » SQL & PL/SQL » SQL & PL/SQL » Index Monitoring Usage (DB: Oracle 9i,, OS: RHEL 2.1 AS)
Index Monitoring Usage [message #397847] Tue, 14 April 2009 03:30 Go to next message
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Friends

I want to know how many queries use the index and how many
times those queries were executed.

I have read some time before that the information may be derived from v$sql_plan , v$sql .But how can i get those queries which uses my indexes. As i understand for getting this information i do not require index monitoring always on.



Re: Index Monitoring Usage [message #397910 is a reply to message #397847] Tue, 14 April 2009 08:39 Go to previous message
Messages: 25532
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.

You are directed to GOOGLE before posting.

Previous Topic: Count number of "Feb 29"s
Next Topic: ORA-01426: numeric overflow on in code that works with
Goto Forum:

Current Time: Mon Jul 24 10:02:42 CDT 2017

Total time taken to generate the page: 0.20507 seconds