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

Report message to a moderator

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: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
v$sql.executions

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jan 27 00:11:20 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.