High 'latch: library cache' waits and multiple versions of an SQL statement...

 Hi all,

I'm trying to track down the cause of a large number of 'latch: library cache' waits in one of our 10.2.0.5 databases (Solaris 10).

When looking at Enterprise Manager it highlights one SQL statement.  This statement is run by multiple sessions (200+) all connecting as the same database user and accessing the same objects.  The statement uses a bind variable which references a varchar2(11) column.

Here's the statement in question:

SELECT *

FROM sysadm.ps_gu_wlcmpge_r_vw

WHERE emplid = :sNum

sysadm.ps_gu_wlcmpge_r_vw is a view and is defined as:

SELECT DISTINCT b.emplid, 

                c.acad_prog_primary,