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: massive performance drop Oracle 9i on multi processor system (Windows Server 2003, Oracle 9i, 9.2.0.6.0)

Re: massive performance drop Oracle 9i on multi processor system (Windows Server 2003, Oracle 9i, 9.2.0.6.0)

From: <bdbafh_at_gmail.com>
Date: 2 May 2005 07:39:28 -0700
Message-ID: <1115044768.909842.292160@f14g2000cwb.googlegroups.com>


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

Original text of this message

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