Home » RDBMS Server » Enterprise Manager » Emailing Top 10 SQLs to developers (Oracle 10.2.0.3. IBM Aix)
icon7.gif  Emailing Top 10 SQLs to developers [message #322938] Mon, 26 May 2008 21:38 Go to next message
mnlv00
Messages: 8
Registered: May 2008
Junior Member
Hi,
I need to generate the Top 10 SQLs for the last 24 Hrs daily in our database and automatically email to developers for them to take action. How can I do that ? Our OS is IBM AIX. Is there an AWR report/sql that I can generate to get the Top 10 SQLs ?
Pl help and TIA
Moe
Re: Emailing Top 10 SQLs to developers [message #322940 is a reply to message #322938] Mon, 26 May 2008 22:08 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Top 10 SQLs
Top 10 based upon which metric; SQL length, number of rows returned, number of tables involved, or ???????

How do you programatically identify the "top 10 SQLs"?
Re: Emailing Top 10 SQLs to developers [message #322955 is a reply to message #322940] Mon, 26 May 2008 23:19 Go to previous messageGo to next message
mnlv00
Messages: 8
Registered: May 2008
Junior Member
Let's say by elapsed time.
Re: Emailing Top 10 SQLs to developers [message #323180 is a reply to message #322938] Tue, 27 May 2008 10:39 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
AWR reports contain a section labeled "SQL ordered by Elapsed Time"
Previous Topic: HTTP_Server status : NONE ?
Next Topic: Upgrade Oracle 9.2.0.5 to Oracle 10.2.0.3.0
Goto Forum:
  


Current Time: Wed Dec 07 12:21:41 CST 2016

Total time taken to generate the page: 0.06746 seconds