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: performance tuning problem

Re: performance tuning problem

From: Christian GILBERT <externe.gilbert_at_francetelecom.com>
Date: Fri, 05 Jul 2002 11:30:32 GMT
Message-ID: <1103_1025868632@10.193.118.17>


Sur Mon, 1 Jul 2002 19:22:19 -0400, "manley" <manley_at_sympatico.ca> a écrit:
> 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.

Post an explain plan of your query. Received on Fri Jul 05 2002 - 06:30:32 CDT

Original text of this message

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