Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Pinning objects in shared pool

3219198Apr 12 2016 — edited Apr 13 2016

Hello,

I was wondering how to pin a schema object in the shared pool (in memory). I am currently running oracle 11g.

After reading a couple of posts on how to pin objects in memory, I am thoroughly confused on how to do so.

For example, do I have to create a procedure or package of a schema then pin the object (that being a package or procedure) to the shared pool?

For the person who answers the question, could you do an example of pinning the HR schema to the shared pool?

Thank you for the help,

Ryan

This post has been answered by Hemant K Chitale on Apr 12 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 11 2016

Added on Apr 12 2016

#general-database-discussions

8 comments

2,014 views