Library Cache Pin problems

From: ecki <eckard.biskup_at_gmx.de>
Date: 19 Sep 2002 05:13:33 -0700
Message-ID: <60600e9b.0209190413.6c1daca0@posting.google.com>

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 Received on Thu Sep 19 2002 - 07:13:33 CDT