Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: massive performance drop Oracle 9i on multi processor system (Windows Server 2003, Oracle 9i, 9.2.0.6.0)
check to see if shared servers are now being used:
select server, count(1)
from sys.v_$session
group by server;
SQL> select server, count(1)
2 from sys.v_$session
3 group by server;
SERVER COUNT(1)
--------- ----------
DEDICATED 28
SQL> show parameter server
Are the packages pinned (kept) in the shared pool? The effect of multiple CPUs could exacerbate latch contention in the shared pool.
-bdbafh
Received on Mon May 02 2005 - 09:39:28 CDT