How to get sqltext from sqlid, when many sqls of same id are running?
I have many sqls of the same id running, so this doesn't work. I get duplicated lines.
select address, SQL_TEXT fulltext from gv$sqltext where sql_id='1vb5xdmb3zgy5' order by PIECE;
Anyone know of a better way?
Or Perhaps I should add another condition to the WHERE clause, like the 'ADDRESS' column?
thanks
0