Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id 6DAE6196038C for ; Thu, 5 May 2016 22:32:08 +0200 (CEST) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTPS for ; Thu, 5 May 2016 22:32:08 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EB80E36720; Thu, 5 May 2016 16:32:06 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id AQrGS_ekmYzV; Thu, 5 May 2016 16:32:06 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BDAA636713; Thu, 5 May 2016 16:31:54 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 05 May 2016 16:30:33 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D5B4E33A33 for ; Thu, 5 May 2016 16:30:32 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Ldw3zz9CIctL for ; Thu, 5 May 2016 16:30:32 -0400 (EDT) Received: from sasl.smtp.pobox.com (pb-smtp2.pobox.com [64.147.108.71]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id A228523848 for ; Thu, 5 May 2016 16:30:32 -0400 (EDT) Received: from sasl.smtp.pobox.com (unknown [127.0.0.1]) by pb-smtp2.pobox.com (Postfix) with ESMTP id 5B0DD18B18 for ; Thu, 5 May 2016 16:30:32 -0400 (EDT) Received: from pb-smtp2.nyi.icgroup.com (unknown [127.0.0.1]) by pb-smtp2.pobox.com (Postfix) with ESMTP id 5159718B17 for ; Thu, 5 May 2016 16:30:32 -0400 (EDT) Received: from mail-io0-f182.google.com (unknown [209.85.223.182]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by pb-smtp2.pobox.com (Postfix) with ESMTPSA id E069C18B13 for ; Thu, 5 May 2016 16:30:31 -0400 (EDT) Received: by mail-io0-f182.google.com with SMTP id d62so96077473iof.2 for ; Thu, 05 May 2016 13:30:31 -0700 (PDT) X-Gm-Message-State: AOPr4FVYeXHwKYFsUkFeDJ5nHnxBghXDLPlSLSpR21yb2Xl4uaAckDEoCC0Y15xXjfpuu7ssHfgW6BrZVAEg+g== X-Received: by 10.107.130.71 with SMTP id e68mr21753498iod.175.1462480231223; Thu, 05 May 2016 13:30:31 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.58.136 with HTTP; Thu, 5 May 2016 13:30:00 -0700 (PDT) In-Reply-To: References: From: Luis Santos Date: Thu, 5 May 2016 17:30:00 -0300 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: ashtop.sql by Tanel Poder for Oracle 10g To: Sayan Malakshinov Cc: Tanel Poder , Tanel Poder , ORACLE-L Content-Type: multipart/alternative; boundary=001a113ed518ac8c7605321e36af X-Pobox-Relay-ID: 36A84FD6-1300-11E6-BA25-D05A70183E34-02349853!pb-smtp2.pobox.com X-archive-position: 64833 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: lsantos@pobox.com Precedence: normal Reply-To: lsantos@pobox.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --001a113ed518ac8c7605321e36af Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Sayan, no words to express my gratitude to you. But really thank you!!! *--* *Att* *Luis Santos* 2016-05-05 16:56 GMT-03:00 Sayan Malakshinov : > Luis, > > I've modified original ashtop by Tanel to support Oracle 10: > https://gist.github.com/xtender/d62da4356c4134e91c77c3d7f809623c > I've just added version variables from init script by Tanel and added > "&_IF_ORA11_OR_HIGHER" > before ", COUNT(DISTINCT sql_exec_start||':'||sql_exec_id) > dist_sqlexec_seen" > so it works fine on Oracle 10g now > > On Thu, May 5, 2016 at 10:29 PM, Luis Santos wrote: > >> =E2=80=8BBy the script name thi=E2=80=8Bs a 10g version for asqlmon.sql,= another very >> nice script from Tanel Poder. >> >> But I was talking about ashtop.sql. >> >> Unfortunately I sent the wrong link, for asqlmon.sql. Sorry. >> >> Here is the correct link: >> >> http://blog.tanelpoder.com/files/scripts/ash/ashtop.sql >> >> >> >> >> >> >> >> >> *--* >> *Att* >> >> >> *Luis Santos* >> >> >> 2016-05-05 14:49 GMT-03:00 Sayan Malakshinov : >> >>> Hi Luis, >>> >>> yes, I saw several different scripts, and I have own version too: >>> >>> https://github.com/xtender/xt_scripts/blob/master/ash/asqlmon10.sql >>> >>> Moreover, I created the script that calls different scripts depending o= n >>> Oracle version: >>> https://github.com/xtender/xt_scripts/blob/master/ash/asqlmon.sql >>> >>> On Thu, May 5, 2016 at 8:24 PM, Luis Santos wrote: >>> >>>> Is there a 10g compatible version of ashtop.sql, by Tanel Poder? Write= n >>>> by him or another Oracle expert... >>>> >>>> http://blog.tanelpoder.com/files/scripts/ash/asqlmon.sql >>>> >>>> >>>> >>>> >>>> *--* >>>> *Att* >>>> >>>> >>>> *Luis Santos* >>>> >>>> >>> >>> >>> -- >>> Best regards, >>> Sayan Malakshinov >>> Oracle performance tuning engineer >>> Oracle ACE Associate >>> http://orasql.org >>> >> >> > > > -- > Best regards, > Sayan Malakshinov > Oracle performance tuning engineer > Oracle ACE Associate > http://orasql.org > --001a113ed518ac8c7605321e36af Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Sayan, no words to express m= y gratitude to you= . But really thank you!!!


--
Luis Santos

<= /i>

=
=

2016-05-05 16:56 GMT-03:00 Sayan Malakshinov= <xt.and.r@gmail.com>:
Luis,

I've modified original ashtop by Tanel to s= upport Oracle 10: https://gist.github.com/xtender/d62da= 4356c4134e91c77c3d7f809623c
I've just added version variables fr= om init script by Tanel and added "&_IF_ORA11_OR_HIGHER"
= =C2=A0before ", COUNT(DISTINCT sql_exec_start||':'||sql_exec_i= d) dist_sqlexec_seen"
so it works fine on Oracle 10g now

On Thu, May 5, 2016 at 10:29 PM, Luis Santos <lsan= tos@pobox.com> wrote:
=E2=80=8BBy the scri= pt name thi=E2=80=8Bs a 10g version for asqlmon.sql, another very nice scri= pt from Tanel Poder.=C2=A0
=
But I was talking abou= t ashtop.sql.

Unfortunately I sent the wrong link= , for asqlmon.sql. Sorry.
<= br>
Here is the correct lin= k:

http://blog.tanelpoder.com/files/scripts/ash/ashtop.sql=








= --
Att
Luis Santos
=
<= span style=3D"border-collapse:collapse">
=
=

2016-05-05 14:49 GMT-03:00 = Sayan Malakshinov <xt.and.r@gmail.com>:
Hi Luis,

yes, I saw seve= ral different scripts, and I have own version too:

https://github.com/xtender/xt_scripts/blob/master/a= sh/asqlmon10.sql

Moreover, I created the s= cript that calls different scripts depending on Oracle version: https://github.com/xtender/xt_scripts/blob/master/ash/asqlmon.s= ql

On Thu, May 5, 2016 at 8:24 PM, Luis Santos &l= t;lsantos@pobox.com<= /a>> wrote:
Is there a 10g compatible version = of ashtop.sql, by Tanel Poder? Writen by him or another Oracle expert...

http://blog.tanelpoder.com/files/scripts/ash/asqlmon.sql




<= /div>
--
<= div style=3D"margin:0px" align=3D"justify">Att
Luis Santos

<= span style=3D"font-size:13px;border-collapse:collapse">
<= span style=3D"border-collapse:collapse">
=
=



<= font color=3D"#888888">--
<= div>Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
<= div>Oracle ACE Associate
http://orasql.org




--
Best regards,
Sayan MalakshinovOracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

--001a113ed518ac8c7605321e36af-- -- http://www.freelists.org/webpage/oracle-l