OCP Blog
Super DBA
DBMS_SHARED_POOL Package
by Vazha Mantua Tuesday, January 11, 2011 12:51 PM

Hello All,

Mary Christmas and happy New Year.

 

I want tell you about package dbms_shared_pool.

DBMS_SHARED_POOL can be used to manage the affect of the LRU mechanism on the shared pool. It can be used to pin PL/SQL objects, SQL cursors, triggers, and sequences. it enables you to display the sizes of objects in the shared pool, and mark them for keeping or unkeeping in order to reduce memory fragmentation.

 

Install the DBMS_SHARED_POOL package.

run script: $ORACLE_HOME/rdbms/admin/dbmspool.sql;

 

Check for objects in the Shared Pool larger than X KBytes

run procedure
begin
dbms_output.enable(null);  
dbms_shared_pool.sizes(200);
end;

Pin something into the Shared Pool

begin

dbms_shared_pool.keep('SYS.STANDARD');
end;

Unpin something from the Shared Pool

begin

dbms_shared_pool.unkeep('SYS.STANDARD');

end;

 

Check what objects are pinned

SELECT * FROM v$db_object_cache WHERE kept = 'YES';

Tags: ,

Comments (5) -

9/21/2011 11:28:42 PM #

polyurethane finish

Just telling you that I love your web site, and I come here every day for the great information you provide. Thanks so much!

polyurethane finish United States

12/6/2011 9:31:07 AM #

Lexington law reviews

You for so many interesting point here. Your idea will inspired me more to revisit your site more often.

Lexington law reviews United States

1/12/2012 1:21:48 PM #

Boutique PR Agency

You must know, your article goes to the center of the issue. Your pellucidity leaves me wanting to know more. Allow me to forthwith grab your feed to keep up to date with your web site. Saying thanks is simply my little way of saying what a masterpiece for a special resource. Accept my dearest wishes for your inflowing publication.

Boutique PR Agency United States

2/1/2012 3:45:34 PM #

carpet cleaning springwood

Your information has given me a lot of thing to think about on this subject. Compelling writing seems to be your forte. Thank you for your impressive and original writing.

carpet cleaning springwood United States

6/3/2012 2:26:58 AM #

Directory Submission Service

DBMS_SHARED_POOL can be used to manage the affect of the LRU mechanism on the shared pool. It can be used to pin PL/SQL objects, SQL cursors, triggers, and sequences. it enables you to display the sizes of objects in the shared pool, and mark them for keeping or unkeeping in order to reduce memory fragmentation.

Directory Submission Service United Kingdom

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Filter by APML

Calendar

<<  November 2017  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910

View posts in large calendar

TextBox