Index Monitoring Usage [message #397847] |
Tue, 14 April 2009 03:30  |
jimit_shaili
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.
Regards
Jimit
|
|
|
|