| dbms_shared_pool command [message #365886] |
Mon, 06 March 2000 18:17  |
scott
Messages: 73
Registered: September 1999
|
Member |
|
|
I issue the following commands to look at cached objects:
----
SQL>set serveroutput on size 2000;
SQL>execute dbms_shared_pool.sizes(400);
--
and I see this:
SIZE(K) KEPT NAME
------- ------ ---------------------------------------------------------------
744 YES GOLD.PROC_WRITE_TRAINING_NEW (PROCEDURE)
PL/SQL procedure successfully completed.
I issue this command:
SQL>execute dbms_shared_pool.sizes(100);
and I see this:
SIZE(K) KEPT NAME
------- ------ ---------------------------------------------------------------
744 YES GOLD.PROC_WRITE_TRAINING_NEW (PROCEDURE)
121 SYS.STANDARD (PACKAGE)
I'm not seeing 2 triggers and 2 other procedures that also fired prior to taking a look. I want to pin all 5 objects but can't understand why they aren't loaded. Thanks in advance.
|
|
|
|
| Re: dbms_shared_pool command [message #365904 is a reply to message #365886] |
Mon, 13 March 2000 17:28  |
scott
Messages: 73
Registered: September 1999
|
Member |
|
|
|
FYI --- I experimented with the serveroutput buffer, boosting it 60000, and the lower size limit for the search from 50 to 5. My procedures showed up in the 7 to 15K range.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
