Re: connection to the database is slow

> True enough Dimitre.....but, you learn it once, and it will serve you
> well. I think it's a worthwhile investment to learn how to read truss
> output....;-)

> I think on learning you never spend time - you invest time.
>
> In long term, learning new things always pays off.
> You learn truss once and are able to accurately determine where the
> problem lies in the future.
> The other way is do some rule of thumb quick checks every time you hit a
> problem,
> some times this approach pays off fast, sometimes you get completely
> distracted from the root cause of your problem.
>
> In long term - learning wins.

Mark, Tanel,
I think it's a question of methodology and business requirements: in this case I would try to exclude the obvious first (guessing) and it's likely that I can gain time and fix the problem faster. In other words, I would avoid tracing with 10046 a poorly performing sql statement without checking the table structure and the indexes beforehand.

Regards,
Dimitre

--
http://www.freelists.org/webpage/oracle-l