Home » RDBMS Server » Server Administration » dbms_shared_pool command
dbms_shared_pool command [message #365886] Mon, 06 March 2000 18:17 Go to next message
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 Go to previous message
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.
Previous Topic: Summing a column when including one value is based on the existence of another
Next Topic: Re: DML
Goto Forum:
  


Current Time: Wed Oct 21 11:48:45 CDT 2020