Re: ashtop.sql by Tanel Poder for Oracle 10g

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Fri, 6 May 2016 00:14:19 +0300
Message-ID: <CAOVevU42=n7gGoy2OcmY2MPu9Z+y1qozjzweff8UqPZk0TfHdg_at_mail.gmail.com>



Thanks a lot to Tanel :)
On May 5, 2016 23:30, "Luis Santos" <lsantos_at_pobox.com> 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 <xt.and.r_at_gmail.com>:
>
>> 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 <lsantos_at_pobox.com> wrote:
>>
>>> ​By the script name thi​s 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 <xt.and.r_at_gmail.com>:
>>>
>>>> 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 <lsantos_at_pobox.com> 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
>>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 05 2016 - 23:14:19 CEST

Original text of this message