library pin waits on the top 5

   Hello all,

We are having issue with the database specially with waits for library cache pin and latch free waits (DB versio 9.2.0.8).

We found a statement that is not sharing the cursor so, following note 296377.1 we found that the reason why the cursors is not shared is AUTH_CHECK_MISMATCH and LANGUAGE_MISMATCH, resuming:

 select * from v$sql_shared_cursor where kglhdpar = 'C0000001314E7D38'

ADDRESS	KGLHDPAR	AUTH_CHECK_MISMATCH	LANGUAGE_MISMATCH
C0000001314E7478	C0000001314E7D38	N	N
C00000013D13D9C0	C0000001314E7D38	Y	Y

 

This is a statement that does a select to a VIEW. The view contains information from several tables.