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

Home -> Community -> Usenet -> c.d.o.server -> Re: An SQL query lasts 60 seconds...

Re: An SQL query lasts 60 seconds...

From: Mike Hately <mike.hately_at_virgin.net>
Date: 2000/04/09
Message-ID: <8cqul6$i4$1@lure.pipex.net>#1/1

I'm assuming that the user is running SQL*Plus on NT. If that's true, do you get the same result running locally using ORACLE_SID with the same queries?
What happens if you rerun the same query immediately?

Mike Hately

Jerry Gitomer <jgitomer_at_erols.com> wrote in message news: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!
> > ***
> >
Received on Sun Apr 09 2000 - 00:00:00 CDT

Original text of this message

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