v$sql SHARABLE_MEM vs. PERSISTENT_MEM vs. RUNTIME_MEM

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Tue, 29 Mar 2005 17:53:14 GMT
Message-ID: <424990ab.444759219@localhost>

  1* select sum (sharable_mem), sum (persistent_mem), sum(runtime_mem) from v$sql where executions=1
system_at_BASE> /

SUM(SHARABLE_MEM) SUM(PERSISTENT_MEM) SUM(RUNTIME_MEM)

----------------- ------------------- ----------------
         71167790             4230860         31107688

Which memory is part of what in v$sgastat? Trying to see how much memory non-bind statements are taking up.

Thanks

            fixed_sga                      456596
            buffer_cache                134217728
            log_buffer                    1180672
shared pool errors                         111060
shared pool enqueue                       1010664
shared pool KGK heap                         1836
shared pool KQR M PO                      1934712
shared pool KQR S PO                       409776
shared pool KQR S SO                         8192
shared pool KQR X PO                         7296
shared pool sessions                      2669680
shared pool sql area                    113880328
shared pool 1M buffer                     2098176
shared pool KGLS heap                     3133248
shared pool processes                      944000
shared pool parameters                     142168
shared pool free memory                   8652744
shared pool transaction                   1241708
shared pool PL/SQL DIANA                  1068428
shared pool FileOpenBlock                 1755880
shared pool PL/SQL MPCODE                 2709100
shared pool PL/SQL PPCODE                   43664
shared pool library cache                53425660
shared pool miscellaneous                38500356
shared pool PLS non-lib hp                   2068
shared pool joxs heap init                   4220
shared pool sim memory hea                 179432
shared pool table definiti                  20416
shared pool temporary tabl                  41936
shared pool trigger defini                  11096
shared pool trigger inform                    516
shared pool VIRTUAL CIRCUITS              1722600
shared pool dictionary cache              1614976
shared pool KSXR receive buffers          1033000
shared pool KSXR pending messages que      841036
shared pool event statistics per sess    12437880
shared pool fixed allocation callback         388
large pool  free memory                 134217728
java pool   free memory                  16777216

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Tue Mar 29 2005 - 11:53:14 CST