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

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