Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: performance tuning problem
manley wrote:
>
> 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
You'll want some info from v$session_event, v$mystat and v$sess_io. One
possible explanation (and there could be many many others) could IO
contention.
hth
connor
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Fri Jul 05 2002 - 13:05:37 CDT