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 8221D1960242 for ; Thu, 5 May 2016 23:15:56 +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 23:15:56 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 68EA9381C0; Thu, 5 May 2016 17:15:55 -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 ATun0yLmP3p4; Thu, 5 May 2016 17:15:55 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2DCCB38215; Thu, 5 May 2016 17:15:43 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 05 May 2016 17:14:21 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 48B4235FBE for ; Thu, 5 May 2016 17:14:21 -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 N5DMMrPOIJKB for ; Thu, 5 May 2016 17:14:21 -0400 (EDT) Received: from mail-lf0-f53.google.com (mail-lf0-f53.google.com [209.85.215.53]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id BB8CB29A42 for ; Thu, 5 May 2016 17:14:20 -0400 (EDT) Received: by mail-lf0-f53.google.com with SMTP id u64so110906166lff.3 for ; Thu, 05 May 2016 14:14:20 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc; bh=diYJ3Lfc9yd2LQVa9UvrbnXb2b0ueJazdUmNnsjucZo=; b=UvpZYgSL02n+GJAP7odMM4S1PpPfZkVl1pQU/tp8eudiiGxb+20ijLwXs1v4OOn8c/ 3/B49a9Ea44c65FIWNsoCmDnzn2WFjJlCPNGsdzwm/nO7V0CRQZJFTYtjHuFGeI9Zd0w IuEkybE9JFC0k2HixAgyMeCkZOf8iPmvMw1vk9kFj1bnD+iuwh/tvDJp2V9dpT82UBJW jLDjW8im5iyEskzIAxOUVyzPBR6cqIj2X2NnN3ZXKFRLiY2dB272cc+v+xPs4hKh2wC/ viWFZ0bwnrSIakN9C0/FNRwy6hQHpQJ+Z6W4b5CB7S3pnSe6RBtOjkL4OZ5Cfh1Er7dZ y4pw== X-Gm-Message-State: AOPr4FUoZYZiATa1r9MpGK58Tg5HujBAl9lcMEuXlSlXH35TvAN+giALYShl0BXgmGOARAs/VphmwTN/uhGXzw== MIME-Version: 1.0 X-Received: by 10.112.137.104 with SMTP id qh8mr6910665lbb.144.1462482859380; Thu, 05 May 2016 14:14:19 -0700 (PDT) Received: by 10.25.16.83 with HTTP; Thu, 5 May 2016 14:14:19 -0700 (PDT) Received: by 10.25.16.83 with HTTP; Thu, 5 May 2016 14:14:19 -0700 (PDT) In-Reply-To: References: Date: Fri, 6 May 2016 00:14:19 +0300 Message-ID: Subject: Re: ashtop.sql by Tanel Poder for Oracle 10g From: Sayan Malakshinov To: Luis Santos Cc: Tanel Poder , Tanel Poder , ORACLE-L Content-Type: multipart/alternative; boundary=089e0117716d52d50005321ed392 X-archive-position: 64834 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: xt.and.r@gmail.com Precedence: normal Reply-To: xt.and.r@gmail.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 --089e0117716d52d50005321ed392 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thanks a lot to Tanel :) On May 5, 2016 23:30, "Luis Santos" wrote: > 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 >>>> on 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? >>>>> Writen 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 >> > > --089e0117716d52d50005321ed392 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Thanks a lot to Tanel :)

On May 5, 2016 23:30, "Luis Santos" &l= t;lsantos@pobox.com> wrote:
Sayan, no words to express my gratitude to you. But really thank you!= !!

<= span style=3D"border-collapse:separate;font-size:small">

--=
Att
Luis Santos


<= /span>
=

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 <lsantos@pobox.com> w= rote:
=E2=80=8BBy the script name thi=E2=80=8Bs a 10g ve= rsion for asqlmon.sql, another very nice script from Tanel Poder.=C2=A0

But I was talking about ashtop.sql.

Unfortunately I sent the wrong link, for asqlmon.sql. Sorry.

Here is the correct link:

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








--
Att
Luis Santos


=
=

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

--089e0117716d52d50005321ed392-- -- http://www.freelists.org/webpage/oracle-l