Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Oracle 10g for solaris 10 Oracle
  • UNderstand and eliminate Latch contention. Oracle
  • Add new columns in dataframe Python/PySpark
  • Settting up get_vmstat.sh for colletinf CPU Usage. Oracle
  • pvm_pre_change.sql Oracle
  • SQL Tracker by SID sqltrackerbysid.sql Oracle
  • 339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
  • Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1 Oracle
  • ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
  • Trace a SQL session from another session using ORADEBUG Oracle
  • backspace in SQL Plus not working then..? Linux/Unix
  • PHP code to add WordPress posts in bulk programmatically PHP/MYSQL/Wordpress
  • initUOCIOTTO.ora Oracle
  • TOP-N Sql to find Nth max or Top N rows Oracle
  • Explain Plan Doesn’T Change For Sql After New Statistics Generated 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

  • SQL_PLAN.sql for checking real execution plan Oracle
  • DBMS_UTILITY PACKAGE Oracle
  • Pending Transaction Neighbors Script Oracle
  • refre.sql for multitenant Oracle
  • create user with unlimited quota Oracle
  • Oracle Recommended Patches — Oracle Database ID 756671.1 Oracle

Leave a Reply Cancel reply

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

Categories

  • AMC10 (0)
  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (9)
  • Videos (0)

Recent Posts

  • Tutornet.US — Source of excellent learning14-Oct-2026
  • OCI Infrastructure Patching14-Oct-2026
  • Free API credits for AI models14-Oct-2026
  • AMC1020-Sep-2026
  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Sample WW22 listener.ora Oracle
  • Removing Blank lines from file using grep Linux/Unix
  • sqlnet.ora paramters Oracle
  • TABLE SIZING WITH DB_BLOCK ARCHITECTURE Reference : Metalink note : 10640.1 Oracle
  • RAC 11g with vmware Oracle
  • create database syntax Oracle
  • Free conference number from http://www.freeconference.com Oracle
  • Zip and unzip with tar Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme