Home » SQL & PL/SQL » SQL & PL/SQL » 121 library cache
121 library cache [message #19863] Mon, 15 April 2002 03:06 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
How to tune library cache?

Report message to a moderator

Re: 121 library cache [message #19874 is a reply to message #19863] Mon, 15 April 2002 16:43 Go to previous message
seng
Messages: 191
Registered: February 2002
Senior Member
to tune this library cache, you need to check this view v$librarycache. All of % of values should maintence more 80%. To increase this %, you need to add more shared_pool_size. Hope this is helping.

Report message to a moderator

Previous Topic: Trigger Visibility??
Next Topic: Select versus Delete?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 01:07:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.