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
