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

Report message to a moderator

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: 26766
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"?

Report message to a moderator

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.

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
Senior Member
AWR reports contain a section labeled "SQL ordered by Elapsed Time"

Report message to a moderator

Previous Topic: HTTP_Server status : NONE ?
Next Topic: Upgrade Oracle 9.2.0.5 to Oracle 10.2.0.3.0
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 21:49:56 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.