Re: An SQL query lasts 60 seconds...

Interesting thought.

Are talking about connections from NT front-ends to Unix servers ?

I used to run Samba on my HP9000 so that I could backup my NT to the HP.

When I upgraded NT to SP3 it suddenly took the NT a minute to find any volumes on the HP. Is this a coincidence or what ?

P.S. Does anyone have Samba working on
HPUX 11 yet ?

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Jerry Gitomer wrote in message <38EC0A24.85DB6CDF_at_erols.com>...


>pavel_sustr wrote:

>>

>> Sorry guys, but you don't seem to understand the problem. It's not your

>> fault, because I don't have enough information either (you know how it

>> is when a customer starts complaining about something ;) but the

>> problem is that

>>

>> ***

>> _ANY_ _QUERY_ lasts more than a minute, even a simple query in SQL Plus!

>> ***

 


> SET TIMING ON  and get the timing data for Oracle.  I suspect

>you will find that the bulk of the time is either disk I/O time

>or network time.  If you are on Unix you can check disk I/O

>activity using monitor or top or iostat.  Networks are harder to

>evaluate since, if the ones I have had to deal with are typical,

>most Network Managers are extremely defensive and unwilling to

>cooperate.  (I think the NT guys are afraid you will recommend

>Novell and vice versa)

>