Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • telnet listening Linux/Unix
  • move_arch_files.ksh Linux/Unix
  • ORA-8031 issue and solution if it is occuring due to truncate. Oracle
  • To see only files and/or folders using LS command Linux/Unix
  • sqlnet.ora paramters Oracle
  • RAC 11g with vmware Oracle
  • Find_stale_dr.sql finding stale physical DR.. Oracle
  • Formatter Explain plan Output 1 Oracle
  • ORACLE_SID in sqlplus Oracle
  • Drop database in Oracle 10g Oracle
  • Load testing on Oracle 19C RAC with HammerDB Oracle
  • Rename Tablespace Oracle
  • initUOCIOTTO.ora Oracle
  • Drop tempfiles from database Oracle
  • Some OS level threshold for performance. 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

  • Does DBMS_JOB recompute the NEXT_DATE interval after or before Oracle
  • How to specify 2 arch location to avoid any kind of DB hanging. Oracle
  • All About Trace Fils Oracle
  • Error Handling in Proc Oracle
  • Composite Index creation tip from Vivek Oracle
  • Oracle Support Metalink ID 161818.1 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 (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (342)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • 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

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Jai Shree Ram Oracle
  • Validating ORACLE_SID againt oratab file. Linux/Unix
  • upload.html PHP/MYSQL/Wordpress
  • scripts to take listener.log backup Linux/Unix
  • Nice Article about semaphores and init.ora Processes parameter relations Linux/Unix
  • Windows based Command line mailing program like mailx (Sednmail for windows) PHP/MYSQL/Wordpress
  • Very Good Oralce Internal Tuning Book Oracle
  • v$event_name Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme