Change:  1 CURSOR 1211552 SELECT * FROM "MGR"."V_AM" 2 CURSOR 1211528 SELECT * FROM "VACM" 1 INDEX 12662 WRH$_SQLSTAT_INDEX 2 INDEX 12367 WRH$_INST_CACHE_TRANSFER_PK 1 INVALID NAMESPACE 36557 ALERT_QUE 2 INVALID NAMESPACE 10583 CURRENT_OPEN_WINDOW 1 PUB_SUB 3900 DATABASE 2 PUB_SUB 2231 CM_MOT_ADMIN 1 RSRC CONSUMER GROUP 4994422 XDLDSgWaQWxA/gQFs91uYj2A== 2 RSRC   View changes from previous version. (Word count: 2286)

Change: 1 SUMMARY 48387 FREETIMELIST2 SUMMARY 9468"SYS"."ALERT_QUE":"BEDB02_TRUEIN_3872_BE PPMEDIACHARGE1 TABLE/PROCEDURE 499828978251 STANDARDACM 2 TABLE/PROCEDURE 286399501561 DBMS_RCVMANCONCURRENT 1 TRIGGER 548162883 EXPFIL_RESTRICT_TYPEEVOLVEACM_INS_TRI 2 TRIGGER 512060067 SDO_TOPO_DROP_FTBLACM_UPD_TRIMemory Heaps One of the popular misconceptions is that we   View changes from previous version. (Word count: 2379)

Change: of the Shared COMPONENTSPoolGenerally what is of far greater interest to the DBA, are the allocation of memory that can be aged in and out of   View changes from previous version. (Word count: 2390)

Change: Moved by jonah.harris Mar 10 2008, 7:40 PM EDT

Change: <pre>SELECT * FROM(SELECT NAME, BYTES/(1024*1024) MBFROM V$SGASTATWHERE POOL = 'shared pool'ORDER BY BYTES DESC)WHERE ROWNUM <= 10;NAME MB-------------------------- ----------free memory 3704.85709CCursor 221.010124kglsim object batch 82.8534851sql area 66.6449738kglsim heap 58.8817749gcs resources 53.3394012Cursor Stats 49.4467545PCursor 33.8289948   View changes from previous version. (Word count: 2385)

Change: amountamong large numbers of users. DBAs often spent much time learning about the shared pool memorymanagement and configure and tune shared pool usage.The Automatic Shared Memory Management (ASMM) features introduced in 10GR1 solved this problemby providing the DBA a simple,   View changes from previous version. (Word count: 2385)

Change:  583 583dc_segments 39302115 51473 988 988dc_sequences 62614 22858 5 5dc_table_scns 7998266 1693264 10 10dc_tablespace_quotas 33651 642 3 3dc_tablespaces 88891887 130 103 103dc_usernames 20403560 638 25 25dc_users 256103233 1805 119 119global database name 98 24 0 0outstanding_alerts 811217 790511 199 199...   View changes from previous version. (Word count: 2386)

Change: All SQL cursors and PL/SQL packages a re allocated almost totally in 4K chunks. The bigger the cursor, the more 4K chunks we allocate to   View changes from previous version. (Word count: 2386)

Change: Usually these individual objects are not large, but they can grow to be several MB based on the object type and its defining attributes. Not surprisingly, a package body containing many procedure s is likely to consume more space in the shared pool than a simple select statement. The   View changes from previous version. (Word count: 858)

Change: Created by surachart Oct 22 2007, 9:02 AM EDT for: no reason given