Re: connection to the database is slow
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 3 Feb 2006 14:55:27 -0600
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.
Agreed - we were talking about somewhat different things here.
Learning and consistent methodology always pays off, but if you are
acquintant with the system, it is worth to check out the issues what have
"usually been a problem". But normally when you have exhausted the "usual
suspects" from your experience only, it's worth to switch to a from top-down
methodology.
Tanel.
--
//www.freelists.org/webpage/oracle-l
Other related posts: