DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Forever in SGA

  1. 03-12-2001, 07:35 PM #1
    farrokhp
    farrokhp is offline Senior Member
    Join Date
    Nov 2000
    Posts
    416
    How can I Pin a stored procedure in SGA. Syntax please?

    Reply With Quote Reply With Quote
  2. 03-12-2001, 11:24 PM #2
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    The pl/sql command to pin a package:

    SQL> execute dbms_shared_pool.keep ('schema_name.package_name');

    Sanjay
    Reply With Quote Reply With Quote
  3. 03-13-2001, 10:15 AM #3
    farrokhp
    farrokhp is offline Senior Member
    Join Date
    Nov 2000
    Posts
    416
    Thanks Sanji
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width