Database Administration (MOSC)

MOSC Banner

Huge trace files with "LIBRARY OBJECT PIN" generated

Hello,

My DB version is 19.19 and I was contacted by our IT team about the fact they've been facing a lot of trace files on the DB server, which quickly fills up the space. Among those files some are huge (1Gb or more), and seem to contain information about the LIBRARY OBJECT PIN event.

For example, one of these file names is XXXX_ora_3923853.trc, and the contents looks like a repetition of package names experiencing a library cache pin, for example:

SO: 0x1f80b77b8, type: LIBRARY OBJECT PIN (119), map: 0x1f8564e50
          state: LIVE (0x4532), flags: 0x1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center