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@xxxxxxxxx>:
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@xxxxxxxxx> wrote:
By the script name this 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@xxxxxxxxx>:
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@xxxxxxxxx> 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
