Re: Library Cache Pin problems

On 19 Sep 2002 05:13:33 -0700, eckard.biskup_at_gmx.de (ecki) wrote:

>Hi all,
>
>I got some problems with Oracle and Library Cache pin's.
>
>Situation:
>==========
>Oracle version: 8.1.7.4
>OS: Solaris 8
>Hardware: Sun Fire 15000
>Total size of database: 2,5 TB
>Involved Application: Specific ERP-Application with Oracle Backend
>
>Sometimes the database got in trouble with library cache pin's (93%
>within Stats Pack). All transactions which were running at this time
>ran very slow. The reason for that situation is likely unclear. But my
>question is, even if the ERP-application generates the problem, what
>can be done to prevent this situation in general?
>
>Thanks for your help
>
>Eckard

Increase the size of the shared pool

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Sep 19 2002 - 11:50:28 CDT