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: