1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

ORACLE Tutorials

Pinning and Bulk Collect

STEP 1
select address, hash_value SQL_TEXT, SHARABLE_MEM from v$sql
where sql_text like '%SCOTT%';

result :

ADDRESS SQL_TEXT SHARABLE_MEM
-------- ---------- ------------
66B99A70 3034598329 42955

STEP 2


SQL> @'C:\oracle\rdbms\admin\dbmspool.sql'

Package created.


Grant succeeded.


View created.


Package body created.

STEP 3 :

SQL> EXEC DBMS_SHARED_POOL.KEEP('Y');

PL/SQL procedure successfully completed.

step 4

SQL> select name, namespace, sharable_mem, kept from
v$db_object_cache where name = 'Y';

NAME
--------------------------------------------------------------------------------

NAMESPACE SHARABLE_MEM KEP
---------------------------- ------------ ---
Y
TABLE/PROCEDURE 11261 YES

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy