Memory Parameters of DB Instance
We can check our DB instance's memory parameters info, their usage, free space and also increase the value if required. Below are some queries which are frequently used by me to take snap of my db instance's memory SGA: ---- sgainfo can be found by SQL> select name, bytes/1024/1024 MB from v$sgainfo; NAME MB -------------------------------- ---------- Fixed SGA Size 2.09999084 Redo Buffers 29.5078125 Buffer Cache Size 27872 Shared Pool Size 4096 Large Pool Size 608 Java Pool Size 160 Streams Pool Size 0 Granule Size 16 Maximum SGA Size 32768 Startup overhead in Shared Pool 240 Startup NUMA Shared Pool memory 320 Free SGA Memory Available 0 At present db instance is using how much sga and how much sga is free f...