RE: NT -> Win2K causes performance degradation..

Might also be they bumped shared_pool way up and they aren't using bind variables?

> -----Original Message-----
>
> When they upgraded the memory, by just now much did they increase
> db_block_buffers?
>
> If increased too much, they could be spending a lot of time
> waiting on latches, as there may be too much memory to
> search through.
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <Stephen.Lee_at_DTAG.Com
  INET: Stephen.Lee_at_DTAG.Com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).