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
Post a Comment