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

From: Luis Santos <lsantos_at_pobox.com>
Date: Thu, 5 May 2016 17:30:00 -0300
Message-ID: <CAPWdmV__SA6=74xvwa1cd4HwFWwvtJiiLxsRXVVHiZi1FDuJGw_at_mail.gmail.com>

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 - 22:30:00 CEST