Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Oracle Data Direct to TAPE Oracle
  • How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
  • To find all disk io ( EMC as well as local) Linux/Unix
  • Exadata Basics Oracle
  • chk_space_SID.ksh Linux/Unix
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • PLSQL Table Syntax 2 Oracle
  • To find explain plan for a statement that occurred in past. Oracle
  • Alter procedure auditing Oracle
  • Another Tuning Article for subheap of shared pool Oracle
  • oracle tips… from http://www.bijoos.com/oracle/douknow.htm Oracle
  • Search and replace editor command in vi Linux/Unix
  • To Find Orphan OS processes. Linux/Unix
  • USER_TABLES.Freelists Oracle
  • On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) 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

  • True Session Wait Activity in Oracle 10g Verygood Oracle
  • 276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node Oracle
  • FRA Information. Oracle
  • How to stop OCSSD Daemon Oracle
  • Sending SQLPLUS output in HTML format Oracle
  • Error Handling in Proc 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 (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Pending Transaction Neighbors Script Oracle
  • Finding locked objects Oracle
  • DBA_HIST_SQLSTAT contents Oracle
  • Temporary Tablespsace Temp tablespace behaviour Oracle
  • cold backup scripts to copy locally Linux/Unix
  • All About Trace Fils Oracle
  • How to start CRS manually Oracle
  • SQL Tracker by SID sqltrackerbysid.sql Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme