How To ?

Google
 
Web teachmeoracle.com
Home Overview Architecture Installation Patching Training Feedback
 
My Blog
WebServer
Concurrent
Autoconfig
Cloning
Training
Apps Interview Q's
Tuning
Contact Us
 
 
Related Pages

Scripts to find patch Info

Health Check 11i

11i Interview Q's

Apps JVM

Metalink Notes

Component Versions

Important Tables

Profile Options

Useful Unix Commands How to ??? Section

 
 
    If you want to Ask any How to ? Question for Oracle Applications like How to Configure Shared APPL_TOP, SSL, Monitoring, Add Node, Backup, Start/Stop Services in Oracle Applications then Mail Me.  Q. How can we pining the objects in database ?

For Oracle Applications you can use script ADXGNPIN.sql (for Package & Functions) and ADXSPPNS.sql (for Sequences) at $AD_TOP/sql/ADXGNPIN.sql on concurrent Manager tier. *These scripts will pin all objects.
For pinning individual objects use
SQL> execute dbms_shared_pool.keep('APPS.FNDCP_TMSRV');


 


  
How to access Apps from Linux Client
 

Oracle Apps 11i | Oracle Portal | Collaboration Suite | My Blog
Copyright © teachmeoracle.com
This work is copyright protected, Copying content from this site is illegal