sql - How to check instant buffer cache size in oracle database with ASMM? -


i'm trying make piechart shows sga components such java pool,large pool etc. 1 of components buffer cache.

i check parameters in sgainfo view, example:

sql> select * v$sgainfo   2  ;  name                                  bytes res -------------------------------- ---------- --- fixed sga size                      2261448 no redo buffers                      226615296 no buffer cache size                3.3957e+10 yes shared pool size                 3623878656 yes large pool size                   671088640 yes java pool size                    671088640 yes streams pool size                         0 yes shared io pool size                       0 yes granule size                      134217728 no maximum sga size                 3.9152e+10 no startup overhead in shared pool  2780532240 no  name                                  bytes res -------------------------------- ---------- --- free sga memory available                 0  12 rows selected. 

but problem is, i'm working on database has asmm(automatic shared memory management) means sga size automatically controlled(so it's components values changing). need instant values of components. can java,shared , large pool's values sgastat view, not buffer cache's value.

sql> col bytes 99999999999999999999999 sql> select * v$sgainfo;

name                                                bytes res -------------------------------- ------------------------ --- fixed sga size                                    2545736 no redo buffers                                     69644288 no buffer cache size                            429765165056 yes shared pool size                              64424509440 yes large pool size                                 268435456 yes java pool size                                  201326592 yes streams pool size                               268435456 yes shared io pool size                                     0 yes granule size                                     67108864 no maximum sga size                             495000064000 no startup overhead in shared pool               25433410328 no free sga memory available                               0  12 rows selected. 

Comments

Popular posts from this blog

Android layout hidden on keyboard show -

google app engine - 403 Forbidden POST - Flask WTForms -

c - Why would PK11_GenerateRandom() return an error -8023? -