Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • create user with unlimited quota Oracle
  • Parallel DML Oracle
  • 10g oem configuration Oracle
  • Windows based Command line mailing program like mailx (Sednmail for windows) PHP/MYSQL/Wordpress
  • To check whether standby is recovering properly or not?? Oracle
  • Generating XML from SQLPLUS Oracle
  • How to collect CPU usage on Linux using Shell script Linux/Unix
  • Oracle 11g RAC on OEL 5 and Vmware 2 Oracle
  • secure crt settings Linux/Unix
  • Python class import from different folders Python/PySpark
  • eplan9i.sql Oracle
  • oracle fast start failover best practice Oracle
  • online_ts_bkup.sql Oracle
  • Alter procedure auditing Oracle
  • Jai Shree Ram Oracle

DBMS_Shared_pool pinning triggers

Posted on 02-May-2007 By Admin No Comments on DBMS_Shared_pool pinning triggers

How to pin a stored procedure/functions ?

1.You can pin procedures and triggers with the dbms_shared_pool procedure.

Either procedures or packages can be pinned with the ‘P’ flag, which is

the default value (so you can leave it out). Triggers are pinned with

‘R’ and anonymous plsql blocks need any letter other than [p,P,r,R] as a

flag. Refer to dbmspool.sql for more documentation. Here is an example:

execute dbms_shared_pool.keep(owner.trigger, ‘R’)

Oracle, SQL scripts

Post navigation

Previous Post: TOP-N Sql to find Nth max or Top N rows
Next Post: Find nth max and min.

Related Posts

  • get_vmstat_linux Oracle
  • lck.sql Oracle
  • Very clear article about oracle dataguard Oracle
  • Changing Instance Name ( No DB_NAME) Oracle
  • shr1.sql for MTS or Shared server configuration Oracle
  • Rman Notes -1 Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Exadata Basics Oracle
  • Jai Shree Ram Oracle
  • CPU speed on solaris Linux/Unix
  • longtx.sql with the flag whether session is blocking any DML locks or not. Oracle
  • create database link syntax Oracle
  • Alter procedure auditing Oracle
  • Validating ORACLE_SID againt oratab file. Linux/Unix
  • Changing the Global Database Name Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme