Re: performance tuning problem

hi too,

what are your instance specs ?
have you checked taskmanager (io,cpu ...)

smells like resource problem but i may be wrong  

regards

s.kapitza

"manley" <manley_at_sympatico.ca> wrote in message news:<bu4V8.12771$P53.1600521_at_news20.bellglobal.com>...
> Hi, everyone:
>
> I have a strange problem: I have an Oracle 8i database running in W2K server
> ( only 256M RAM, that's low) with a very large table called Table1 ( about 4
> millions records). I issued a SQL query at that table in the server machine
> , like
> SQL> select col1 from table1 where col1='value1';
>
> It takes about 2 minutes or so. But if I open two sessions simultaneously
> and issue the same query like above , the performance is dynamically
> dropped, it takes about 20 minutes or more to finish.
>
> TIA
Received on Fri Jul 05 2002 - 18:02:36 CDT