Home » SQL & PL/SQL » SQL & PL/SQL » Index Monitoring Usage (DB: Oracle 9i, 9.2.0.1.0, OS: RHEL 2.1 AS)
Index Monitoring Usage [message #397847] Tue, 14 April 2009 03:30 Go to next message
jimit_shaili
Messages: 231
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

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

You are directed to GOOGLE before posting.



http://www.google.com/search?hl=en&q=oracle+monitor+index+usage&aq=4&oq=oracle+moni
Previous Topic: Count number of "Feb 29"s
Next Topic: ORA-01426: numeric overflow on 10.0.2.0.4 in code that works with 9.0.2.0.8
Goto Forum:
  


Current Time: Sun Dec 04 04:37:49 CST 2016

Total time taken to generate the page: 0.03733 seconds