OraFAQ Forum: Server Administration » How to know which query runs many times

Home » RDBMS Server » Server Administration » How to know which query runs many times (11g, Server 2003)

Sat, 01 August 2009 01:54

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

Sat, 01 August 2009 03:30

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

v$sql.executions

Regards
Michel

Sat, 01 August 2009 03:40

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: Thu Apr 23 11:48:25 CDT 2026