Toad World® Forums

SQL analysis


On the accountancy database we have a lot of very large SQL statements that consume a lot of ressources. First of all, we would like to find which ones are bad, but the navigator crashes (SQL Nav >= 7.2) when we try to see the statement :

We then use other oracle products to find the statetement, and then we try to analyse this one with the explain plan. In this one we get error OCI-22053 : overflow error (SQL Nav >=7.2, in 6.7 crash)