Tuesday, 7 August 2018

Query to find the SQL Statements with Multiple SQL IDs | Oracle Database

How to find the SQL Statements with Multiple SQL IDs in Oracle Database?




Below mentioned queries can help you find the SQL Statements having multiple unique SQL IDs:


SELECT substr(sql_text,1,40), count(1)
FROM gv$sqlarea
group by substr(sql_text,1,40)
order by count(1) asc;

2 comments:

  1. Is It Any good to get a no deposit bonus for a coin casino? - Casino Whizz
    Online casinos 1xbet korean will offer you a no deposit deccasino bonus up to $200. No Deposit Casino Bonuses, no deposit free spins, 인카지노 no deposit bonus codes.

    ReplyDelete
  2. Casino Night: Slots & Live Dealer Games - DRMCD
    Play your favorite table games from the comfort of your own 삼척 출장안마 home! No matter where 구미 출장샵 you're located, no matter what you're playing 제천 출장샵 or 김포 출장샵 a party in, the casino 충청남도 출장안마

    ReplyDelete