Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • good note for shared pool tunnig Oracle
  • online_bkup.sql Oracle
  • alter database backup controlfile to trace Oracle
  • copying/removing directory with all its subdirectory Linux/Unix
  • catall.sh Linux/Unix
  • To find explain plan for a statement that occurred in past. Oracle
  • Adding Datafile on Primary Server and Impact on Standby Server Oracle
  • DBA_HIST_SQLSTAT contents Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • To seee semaphores and shared memory segments in Solaris Linux/Unix
  • How to Use DBMS_STATS to Move Statistics to a Different Database Oracle
  • find_cons.sql Oracle
  • Windows based Command line mailing program like mailx (Sednmail for windows) PHP/MYSQL/Wordpress
  • Find long Running Transaction Linux/Unix
  • switchlogfile.sh Linux/Unix

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

  • online_ts_bkup.sql Oracle
  • standard Monitoring – 1 Oracle
  • Transfer SQL Profiles from One database to other database. Oracle
  • Another Tuning Article for subheap of shared pool Oracle
  • Optimizer SORT Operations Oracle
  • Find nth max and min. Oracle

Leave a Reply Cancel reply

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

Categories

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

Recent Posts

  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025
  • MYSQL and Oracle Comparison for Oracle DBA24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • SQL Server: How to see historical transactions SQL Server
  • replacing ^M character when passing files from Windows to Unix Linux/Unix
  • Which environment is used by currently running process ( Very good) Linux/Unix
  • Oracle 10g Installation/Applying Patches Tips Oracle
  • How to hide author name in WordPress BLOG PHP/MYSQL/Wordpress
  • DB Console Mainenance. Oracle
  • Resolving RMAN Hung Jobs Oracle
  • create PLAN_TABLE command. Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme