Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: connection to the database is slow

Re: connection to the database is slow

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Fri, 3 Feb 2006 14:55:27 -0600
Message-ID: <010301c62904$2c161310$78bc21c8@porgand>


> 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.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 03 2006 - 14:55:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US