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....;-) -Mark -- Mark J. Bobak Senior Oracle Architect ProQuest Information & Learning "There are 10 types of people in the world: Those who understand binary, and those who don't." ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dimitar Radoulov Sent: Friday, February 03, 2006 2:20 PM To: Thomas A. La Porte Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: connection to the database is slow On 2/3/06, Thomas A. La Porte <tlaporte@xxxxxxxxxxxxxxxxxxx> wrote: There isn't a mention of platform (client or server), but it would be useful to truss or strace the client process if you are on a Unix box. That should give you an indication of where the time is being spent, much like a 10043 trace. No sense guessing if you have tools available to tell you what's wrong. I agree ..., but you have to consider the time you have to spend to learn to interpret the trace/strace/truss output :) Regards, Dimitre
BEGIN:VCARD VERSION:2.1 N:Bobak;Mark FN:Bobak, Mark ORG:ProQuest Information and Learning;Database Group TITLE:Software Architect, Sr-TPD TEL;WORK;VOICE:734.975.6086 ADR;WORK:;ECC4-N01E04;1400 Eisenhower Parkway LABEL;WORK;ENCODING=QUOTED-PRINTABLE:ECC4-N01E04=0D=0A1400 Eisenhower Parkway EMAIL;PREF;INTERNET:Mark.Bobak@xxxxxxxxxxxxxxx REV:20051213T223654Z END:VCARD