Home » RDBMS Server » Server Administration » How to know which query runs many times (11g, Server 2003)
How to know which query runs many times [message #416360] Sat, 01 August 2009 01:54 Go to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Hi all,

How can we know that which query gets executed so many times?

regards,
Delna
Re: How to know which query runs many times [message #416368 is a reply to message #416360] Sat, 01 August 2009 03:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
v$sql.executions

Regards
Michel
Re: How to know which query runs many times [message #416370 is a reply to message #416360] Sat, 01 August 2009 03:40 Go to previous message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Thank you Michel sir.

regards,
Delna
Previous Topic: Tablespace usages
Next Topic: Getting error when I invoke dbca
Goto Forum:
  


Current Time: Fri Dec 02 12:28:05 CST 2016

Total time taken to generate the page: 0.05214 seconds