OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » sql execution (oracle 11g/r2 unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sql execution [message #609018]

Fri, 28 February 2014 01:05

balaji123
Messages: 29
Registered: October 2009
Location: sanfrancisco

Junior Member

Oracle sql DBA question, Please advise.

how to find how many times particular SQL runs a day ? is there any dba tables , which we can identify based on "SELECT c1,c2" string.

Please advise.

Report message to a moderator

Re: sql execution [message #609022 is a reply to message #609018]

Fri, 28 February 2014 01:22

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is not directly recorded.
You can query v$sqlarea for the total of executions during the instance life.
If you bought diagnostic and tuning pack, you can query dba_hist_sqlstat.

Report message to a moderator

Re: sql execution [message #609036 is a reply to message #609018]

Fri, 28 February 2014 03:32

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

If the SQL is captured in snapshots, you can get this from statspack or (if you have the licence) AWR reports. But it might not have been captured, depending on your thresholds.

Report message to a moderator

Re: sql execution [message #609037 is a reply to message #609036]

Fri, 28 February 2014 03:37

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

You can color it, if it's important enough.

Report message to a moderator

Previous Topic:	PIVOT - SQL Command not properly ended
Next Topic:	SQL code to retrieve items in consective periods

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 15:54:47 CDT 2024