This discussion is archived
3 Replies Latest reply: Jun 21, 2012 12:29 AM by 933257 RSS

history of Frequency of excution of a particular sql?

933257 Newbie
Currently Being Moderated
Hi I am using Oracle 10g.

I am having a particular SQL, i want to know the frequency/count of execution of this particular sql in my prod DB. how can i get this. I get the sql in v$sql but didnt get the same record in dba_hist_sqlstat view.

Edited by: 930254 on Jun 18, 2012 3:19 AM

Edited by: 930254 on Jun 18, 2012 3:19 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points