{"id":2890,"date":"2017-10-18T10:50:34","date_gmt":"2017-10-18T12:50:34","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=2890"},"modified":"2017-10-18T14:14:59","modified_gmt":"2017-10-18T16:14:59","slug":"vsga-vsgainfo-and-vsgastat-matching-bytes-challenge","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2017\/10\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\/","title":{"rendered":"v$sga, v$sgainfo and v$sgastat matching bytes challenge"},"content":{"rendered":"

Those days I was challenging myself to make an exact match and correlate all lines returned by a select on v$sga, v$sgainfo and <\/span>v$sgastat.<\/span><\/span><\/p>\n

The biggest problem on those v$ views<\/strong> is that they bring different visions of the same thing (SGA), and I could never make a exact match of the bytes before. Now it was time to solve this puzzle. So I’ve built 5 different scenarios playing with AMM (Automatic Memory Management), ASMM (Automatic Shared Memory Management), complete separated pools, in-memory and PDBs.<\/p>\n

Let’s check the results and conclusions. Please share in the comments any finding or anything valuable that you may want to add.<\/strong><\/span><\/p>\n

So for this task, I’ve created a CDB database with default DBCA parameters and than for each scenario I’ve slightly changed some parameters.<\/p>\n

The environment configuration is as follows:<\/span><\/p>\n

Database: 12.1.0.2 + DBBP 170718<\/strong><\/p>\n

Parameter File:<\/p>\n

*.audit_file_dest='\/u01\/app\/oracle\/admin\/orcl\/adump'\r\n*.audit_trail='db'\r\n*.compatible='12.1.0.2.0'\r\n*.control_files='\/u01\/app\/oracle\/oradata\/orcl\/control01.ctl','\/u01\/app\/oracle\/fast_recovery_area\/orcl\/control02.ctl'\r\n*.db_block_size=8192\r\n*.db_domain=''\r\n*.db_name='orcl'\r\n*.db_recovery_file_dest='\/u01\/app\/oracle\/fast_recovery_area'\r\n*.db_recovery_file_dest_size=4560m\r\n*.diagnostic_dest='\/u01\/app\/oracle'\r\n*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'\r\n*.enable_pluggable_database=true\r\n*.memory_target=800m\r\n*.open_cursors=300\r\n*.processes=300\r\n*.remote_login_passwordfile='EXCLUSIVE'\r\n*.undo_tablespace='UNDOTBS1'\r\n<\/pre>\n
All Memory Parameters inferred by Oracle based based on this pfile are:<\/p>\n
SQL> col name for a35\r\nSQL> col value for a35\r\nSQL> set tab off pages 1000 lines 1000\r\n\r\nSQL> select name, type, value from v$parameter where name like '%size%' or name in ('memory_max_target','memory_target','pga_aggregate_target','sga_target') order by 1;\r\n\r\nNAME                                                TYPE VALUE\r\n----------------------------------- -------------------- -----------------------------------\r\nbitmap_merge_area_size                                 3 1048576\r\nclient_result_cache_size                               6 0\r\ncreate_bitmap_area_size                                3 8388608\r\ndb_16k_cache_size                                      6 0\r\ndb_2k_cache_size                                       6 0\r\ndb_32k_cache_size                                      6 0\r\ndb_4k_cache_size                                       6 0\r\ndb_8k_cache_size                                       6 0\r\ndb_block_size                                          3 8192\r\ndb_cache_size                                          6 0\r\ndb_flash_cache_size                                    6 0\r\ndb_keep_cache_size                                     6 0\r\ndb_recovery_file_dest_size                             6 4781506560\r\ndb_recycle_cache_size                                  6 0\r\ndnfs_batch_size                                        3 4096\r\nglobal_context_pool_size                               2\r\nhash_area_size                                         3 131072\r\ninmemory_size                                          6 0\r\njava_max_sessionspace_size                             3 0\r\njava_pool_size                                         6 0\r\nlarge_pool_size                                        6 0\r\nmax_dump_file_size                                     2 unlimited\r\nmax_string_size                                        2 STANDARD\r\nmemory_max_target                                      6 838860800\r\nmemory_target                                          6 838860800\r\nobject_cache_max_size_percent                          3 10\r\nobject_cache_optimal_size                              3 102400\r\nolap_page_pool_size                                    6 0\r\nparallel_execution_message_size                        3 16384\r\npga_aggregate_target                                   6 0\r\nresult_cache_max_size                                  6 2097152\r\nsga_max_size                                           6 838860800\r\nsga_target                                             6 0\r\nshared_pool_reserved_size                              6 6291456\r\nshared_pool_size                                       6 0\r\nsort_area_retained_size                                3 0\r\nsort_area_size                                         3 65536\r\nstreams_pool_size                                      6 0\r\nunified_audit_sga_queue_size                           3 1048576\r\nworkarea_size_policy                                   2 AUTO\r\n\r\n40 rows selected.<\/pre>\n
PDBs of my environment:<\/p>\n
SQL> show pdbs\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       READ ONLY  NO\r\n         3 PDB01                          READ WRITE NO<\/pre>\n
Queries that I used on every Scenario<\/strong><\/em> to check SGA sizes:<\/p>\n
select * from v$sga order by 1;\r\nselect * from v$sgainfo order by 1;\r\nselect nvl(pool,name) pool, sum(bytes), con_id from v$sgastat group by nvl(pool,name), con_id order by 1,3,2;\r\nselect component, current_size, user_specified_size, con_id from v$memory_dynamic_components order by 1;\r\n<\/pre>\n
Let’s begin…<\/p>\n
Scenario 1:<\/span><\/strong><\/h2>\n
For the first scenario I didn’t change anything from the default configuration above. Let’s check the results for the SGA queries and match them.<\/p>\n
\"\"<\/p>\n
So, the SUM of bytes (VALUE column) in v$sga<\/span> is the memory_target<\/strong> parameter (838860800), which is actually SGA + PGA. I’ve put colors for each line so will be easier to match them on next views:<\/p>\n
\"\"<\/p>\n
We can easily match the Buffer Cache<\/strong> (yellow), Fixed SGA Size<\/strong> (orange) and Redo Buffers<\/strong> (light blue) of v$sga<\/span> and v$sgainfo<\/span>.<\/p>\n
However, the Variable Size<\/strong> from v$sga<\/span> is still not easy to match. However, here we have Java\/Large\/Shared\/Streams Pools that we can match with next views (purple).<\/p>\n
\"\"<\/p>\n
The first curious thing that we note when we compare v$sga<\/span> or v$sgainfo<\/span> with v$sgastat<\/span> is that the Shared IO Pool<\/strong> is not part of the Shared Pool<\/strong> but part of the Buffer Cache<\/strong> (you need to SUM both to match with Buffer Cache<\/strong> line of v$sga\/v$sgainfo<\/span>)<\/p>\n
\"\"<\/p>\n
When we add the v$memory_dynamic_components<\/span> into the game, it also confirms the previous conclusion: Shared IO Pool<\/strong> is part of Buffer Cache<\/strong>. Note also that the Free SGA Memory Available<\/strong> of v$sgainfo<\/span> matches the PGA Target<\/strong> of this view, as we are in a AMM environment. In this view, we also don’t have Fixed SGA<\/strong> and Log Buffer<\/strong> as we are talking only about dynamic components.<\/p>\n
So how do we match Variable Size<\/strong> of v$sga<\/span> with the lines from other 3 views? Note that Variable Size<\/strong> is almost the same as Purple (Pools) + Dark Blue (PGA).<\/p>\n
Variable Size<\/strong> = 532679408<\/p>\n
Purple + Blue = 4194304 + 8388608 + 218103808 + 8388608 + 293601280 = 532676608<\/p>\n
The difference (532679408 – 532676608) is actually 2800 bytes<\/strong> only = 350 Kbytes<\/strong><\/p>\n
So in an AMM environment, the Variable Size<\/strong> of v$sga<\/span> means the PGA + Java\/Large\/Shared\/Streams Pool of either v$sgainfo<\/span>, v$sgastat<\/span> or v$memory_dynamic_components<\/span>.<\/p>\n
Conclusions until now:<\/strong><\/span><\/p>\n
    \n
  1. The v$sgainfo<\/span> and v$memory_dynamic_components says that Shared IO Pool<\/strong> is actually part of the Buffer Cache<\/strong> inside the SGA<\/span>.<\/span><\/li>\n
  2. We have a difference of 350 KBytes between the Variable Size<\/strong> and the sum of components inside of it.<\/li>\n
  3. In a AMM environment, SGA Variable Size<\/strong> includes the whole PGA, which makes sense.<\/li>\n<\/ol>\n
    Raw output:<\/p>\n
    SQL> select * from v$sga order by 1;\r\n\r\nNAME                      VALUE     CON_ID\r\n-------------------- ---------- ----------\r\nDatabase Buffers      297795584          0\r\nFixed Size              2929936          0\r\nRedo Buffers            5455872          0\r\nVariable Size         532679408          0\r\n\r\nSQL> select * from v$sgainfo order by 1;\r\n\r\nNAME                                  BYTES RES     CON_ID\r\n-------------------------------- ---------- --- ----------\r\nBuffer Cache Size                 297795584 Yes          0\r\nData Transfer Cache Size                  0 Yes          0\r\nFixed SGA Size                      2929936 No           0\r\nFree SGA Memory Available         293601280              0\r\nGranule Size                        4194304 No           0\r\nIn-Memory Area Size                       0 No           0\r\nJava Pool Size                      4194304 Yes          0\r\nLarge Pool Size                     8388608 Yes          0\r\nMaximum SGA Size                  838860800 No           0\r\nRedo Buffers                        5455872 No           0\r\nShared IO Pool Size                16777216 Yes          0\r\nShared Pool Size                  218103808 Yes          0\r\nStartup overhead in Shared Pool   130751656 No           0\r\nStreams Pool Size                   8388608 Yes          0\r\n\r\n14 rows selected.\r\n\r\nSQL> select component, current_size, user_specified_size, con_id from v$memory_dynamic_components order by 1;\r\n\r\nCOMPONENT                                                        CURRENT_SIZE USER_SPECIFIED_SIZE     CON_ID\r\n---------------------------------------------------------------- ------------ ------------------- ----------\r\nASM Buffer Cache                                                            0                   0          0\r\nDEFAULT 16K buffer cache                                                    0                   0          0\r\nDEFAULT 2K buffer cache                                                     0                   0          0\r\nDEFAULT 32K buffer cache                                                    0                   0          0\r\nDEFAULT 4K buffer cache                                                     0                   0          0\r\nDEFAULT 8K buffer cache                                                     0                   0          0\r\nDEFAULT buffer cache                                                281018368                   0          0\r\nData Transfer Cache                                                         0                   0          0\r\nIn-Memory Area                                                              0                   0          0\r\nKEEP buffer cache                                                           0                   0          0\r\nPGA Target                                                          293601280                   0          0\r\nRECYCLE buffer cache                                                        0                   0          0\r\nSGA Target                                                          545259520                   0          0\r\nShared IO Pool                                                       16777216                   0          0\r\njava pool                                                             4194304                   0          0\r\nlarge pool                                                            8388608                   0          0\r\nshared pool                                                         218103808                   0          0\r\nstreams pool                                                          8388608                   0          0\r\n\r\n18 rows selected.\r\n\r\nSQL> select nvl(pool,name) pool, sum(bytes), con_id from v$sgastat group by nvl(pool,name), con_id order by 1,3,2;\r\n\r\nPOOL                       SUM(BYTES)     CON_ID\r\n-------------------------- ---------- ----------\r\nbuffer_cache                281018368          0\r\nfixed_sga                     2929936          0\r\njava pool                     4194304          0\r\nlarge pool                    7159808          0\r\nlarge pool                    1228800          1\r\nlog_buffer                    5455872          0\r\nshared pool                   9097464          0\r\nshared pool                 187926720          1\r\nshared pool                   7473672          2\r\nshared pool                  13605952          3\r\nshared_io_pool               16777216          0\r\nstreams pool                  8384136          0\r\nstreams pool                     4472          1\r\n\r\n13 rows selected.<\/pre>\n
    Scenario 2:<\/span><\/strong><\/h2>\n
    For this scenario, I will play with Share IO Pool size<\/strong> to ensure that the 16Mbytes was not a coincidence. So, for parameters, everything is the same as before plus:<\/p>\n
    alter system set java_pool_size=10M scope=spfile;\r\nalter system set large_pool_size=20M scope=spfile;\r\nalter system set streams_pool_size=30M scope=spfile;\r\nalter system set \"_shared_io_pool_size\"=40M scope=spfile;<\/pre>\n
    Let’s check the views:<\/p>\n
    \"\"<\/p>\n
    Buffer Cache is now 8 Mbytes bigger than before (306184192-297795584). Everything is matching the same manner.<\/p>\n
    \"\"<\/p>\n
    Java Pool<\/strong> is now with 10Mbytes, Large Pool<\/strong> with 20Mbytes, Streams Pool<\/strong> with 30Mbytes and Shared IO Pool<\/strong> with 40Mbytes, as expected.<\/p>\n
    \"\"<\/p>\n
    Note that the buffer_cache<\/strong> + shared_io_pool<\/strong> from v$sgastat<\/span> is still matching Buffer Cache Size<\/strong> from v$sga<\/span> and v$sgainfo<\/span>.<\/p>\n
    \"\"<\/p>\n
    And the same applies for v$memory_dynamic_components<\/span>. You need to add Shared IO Pool<\/strong> to DEFAULT buffer cache<\/strong> to have a match of Database Buffers<\/strong> of v$sga<\/span>.<\/p>\n
    So, is the Variable Size<\/strong> of v$sga still matching Purple + Blue?<\/p>\n
    Variable Size<\/strong> = 524290800<\/p>\n
    Purple + Blue = 12582912 + 20971520 + 163577856 + 33554432 + 293601280 = 524288000<\/p>\n
    The difference (524290800 – 524288000) is still 2800 bytes<\/strong> = 350 Kbytes<\/strong><\/p>\n
    Conclusions until now: same as before.<\/strong><\/span><\/p>\n
    Raw output:<\/p>\n
    SQL> select * from v$sga order by 1;\r\n\r\nNAME                      VALUE     CON_ID\r\n-------------------- ---------- ----------\r\nDatabase Buffers      306184192          0\r\nFixed Size              2929936          0\r\nRedo Buffers            5455872          0\r\nVariable Size         524290800          0\r\n\r\nSQL> select * from v$sgainfo order by 1;\r\n\r\nNAME                                  BYTES RES     CON_ID\r\n-------------------------------- ---------- --- ----------\r\nBuffer Cache Size                 306184192 Yes          0\r\nData Transfer Cache Size                  0 Yes          0\r\nFixed SGA Size                      2929936 No           0\r\nFree SGA Memory Available         293601280              0\r\nGranule Size                        4194304 No           0\r\nIn-Memory Area Size                       0 No           0\r\nJava Pool Size                     12582912 Yes          0\r\nLarge Pool Size                    20971520 Yes          0\r\nMaximum SGA Size                  838860800 No           0\r\nRedo Buffers                        5455872 No           0\r\nShared IO Pool Size                41943040 Yes          0\r\nShared Pool Size                  163577856 Yes          0\r\nStartup overhead in Shared Pool   130920304 No           0\r\nStreams Pool Size                  33554432 Yes          0\r\n\r\n14 rows selected.\r\n\r\nSQL> select component, current_size, user_specified_size, con_id from v$memory_dynamic_components order by 1;\r\n\r\nCOMPONENT                                                        CURRENT_SIZE USER_SPECIFIED_SIZE     CON_ID\r\n---------------------------------------------------------------- ------------ ------------------- ----------\r\nASM Buffer Cache                                                            0                   0          0\r\nDEFAULT 16K buffer cache                                                    0                   0          0\r\nDEFAULT 2K buffer cache                                                     0                   0          0\r\nDEFAULT 32K buffer cache                                                    0                   0          0\r\nDEFAULT 4K buffer cache                                                     0                   0          0\r\nDEFAULT 8K buffer cache                                                     0                   0          0\r\nDEFAULT buffer cache                                                264241152                   0          0\r\nData Transfer Cache                                                         0                   0          0\r\nIn-Memory Area                                                              0                   0          0\r\nKEEP buffer cache                                                           0                   0          0\r\nPGA Target                                                          293601280                   0          0\r\nRECYCLE buffer cache                                                        0                   0          0\r\nSGA Target                                                          545259520                   0          0\r\nShared IO Pool                                                       41943040            41943040          0\r\njava pool                                                            12582912            12582912          0\r\nlarge pool                                                           20971520            20971520          0\r\nshared pool                                                         163577856                   0          0\r\nstreams pool                                                         33554432            33554432          0\r\n\r\n18 rows selected.\r\n\r\nSQL> select nvl(pool,name) pool, sum(bytes), con_id from v$sgastat group by nvl(pool,name), con_id order by 1,3,2;\r\n\r\nPOOL                       SUM(BYTES)     CON_ID\r\n-------------------------- ---------- ----------\r\nbuffer_cache                264241152          0\r\nfixed_sga                     2929936          0\r\njava pool                    12582912          0\r\nlarge pool                   20480000          0\r\nlarge pool                     491520          1\r\nlog_buffer                    5455872          0\r\nshared pool                   6351424          0\r\nshared pool                 141749672          1\r\nshared pool                   6850024          2\r\nshared pool                   8626736          3\r\nshared_io_pool               41943040          0\r\nstreams pool                 33554432          0\r\n\r\n12 rows selected.<\/pre>\n
    Scenario 3:<\/span><\/strong><\/h2>\n
    Now let’s convert AMM to ASMM and enable In-Memory database option and see what happens. I will keep the environment the same as scenario 2 plus:<\/p>\n
    alter system reset memory_target scope=spfile;\r\nalter system set sga_target=500M scope=spfile;\r\nalter system set pga_aggregate_target=300M scope=spfile;\r\nalter system set inmemory_size=100M scope=spfile;<\/pre>\n
    Checking the v$ views:<\/p>\n
    \"\"<\/p>\n
    v$sga<\/span> now shows a new In-Memory Area<\/strong> line. The SUM of all lines is not including PGA size anymore.<\/p>\n
    \"\"<\/p>\n
    In v$sgainfo<\/span> a the already exitent In-Memory Area<\/strong> line gets populated. Note that the Free SGA Memory Available<\/strong> is now zero as the DB cannot steal memory from PGA in a ASMM database.<\/p>\n
    \"\"<\/p>\n
    In v$sgastat<\/span> we still have the same behavior of buffer_cache<\/strong> line that needs to be added with shared_io_pool<\/strong> line to result in the Buffer Cache Size<\/strong> of previous views.<\/p>\n
    \"\"<\/p>\n
    And how do we match now the Variable Size<\/strong> of v$sga<\/span> with the other views?<\/p>\n
    Variable Size<\/strong> = 285214992<\/p>\n
    Purple = 12582912 + 20971520 + 218103808 + 33554432 = 285212672<\/p>\n
    The difference (285214992 – 285212672) is now 2320 bytes<\/strong> = 290 Kbytes (5 Mbytes less than in AMM)
    \n<\/strong><\/p>\n
    New conclusions:<\/strong><\/span><\/p>\n
      \n
    1. The new difference between the Variable Size<\/strong> and the actual pools dropped from 350 Kbytes to 290 Kbytes.<\/li>\n
    2. In a ASMM env, SGA Variable Size<\/strong> does not include the PGA. This also makes sense.<\/li>\n<\/ol>\n
      Raw output:<\/p>\n
      SQL> select * from v$sga order by 1;\r\n\r\nNAME                      VALUE     CON_ID\r\n-------------------- ---------- ----------\r\nDatabase Buffers      125829120          0\r\nFixed Size              2926320          0\r\nIn-Memory Area        104857600          0\r\nRedo Buffers            5459968          0\r\nVariable Size         285214992          0\r\n\r\nSQL> select * from v$sgainfo order by 1;\r\n\r\nNAME                                  BYTES RES     CON_ID\r\n-------------------------------- ---------- --- ----------\r\nBuffer Cache Size                 125829120 Yes          0\r\nData Transfer Cache Size                  0 Yes          0\r\nFixed SGA Size                      2926320 No           0\r\nFree SGA Memory Available                 0              0\r\nGranule Size                        4194304 No           0\r\nIn-Memory Area Size               104857600 No           0\r\nJava Pool Size                     12582912 Yes          0\r\nLarge Pool Size                    20971520 Yes          0\r\nMaximum SGA Size                  524288000 No           0\r\nRedo Buffers                        5459968 No           0\r\nShared IO Pool Size                41943040 Yes          0\r\nShared Pool Size                  218103808 Yes          0\r\nStartup overhead in Shared Pool   128349688 No           0\r\nStreams Pool Size                  33554432 Yes          0\r\n\r\n14 rows selected.\r\n\r\nSQL> select component, current_size, user_specified_size, con_id from v$memory_dynamic_components order by 1;\r\n\r\nCOMPONENT                                                        CURRENT_SIZE USER_SPECIFIED_SIZE     CON_ID\r\n---------------------------------------------------------------- ------------ ------------------- ----------\r\nASM Buffer Cache                                                            0                   0          0\r\nDEFAULT 16K buffer cache                                                    0                   0          0\r\nDEFAULT 2K buffer cache                                                     0                   0          0\r\nDEFAULT 32K buffer cache                                                    0                   0          0\r\nDEFAULT 4K buffer cache                                                     0                   0          0\r\nDEFAULT 8K buffer cache                                                     0                   0          0\r\nDEFAULT buffer cache                                                 83886080                   0          0\r\nData Transfer Cache                                                         0                   0          0\r\nIn-Memory Area                                                      104857600           104857600          0\r\nKEEP buffer cache                                                           0                   0          0\r\nPGA Target                                                          314572800           314572800          0\r\nRECYCLE buffer cache                                                        0                   0          0\r\nSGA Target                                                          524288000           524288000          0\r\nShared IO Pool                                                       41943040            41943040          0\r\njava pool                                                            12582912            12582912          0\r\nlarge pool                                                           20971520            20971520          0\r\nshared pool                                                         218103808                   0          0\r\nstreams pool                                                         33554432            33554432          0\r\n\r\n18 rows selected.\r\n\r\nSQL> select nvl(pool,name) pool, sum(bytes), con_id from v$sgastat group by nvl(pool,name), con_id order by 1,3,2;\r\n\r\nPOOL                       SUM(BYTES)     CON_ID\r\n-------------------------- ---------- ----------\r\nbuffer_cache                 83886080          0\r\nfixed_sga                     2926320          0\r\njava pool                    12582912          0\r\nlarge pool                   20480000          0\r\nlarge pool                     491520          1\r\nlog_buffer                    5459968          0\r\nshared pool                   4004152          0\r\nshared pool                 198747816          1\r\nshared pool                   6771144          2\r\nshared pool                   8580696          3\r\nshared_io_pool               41943040          0\r\nstreams pool                 33554432          0\r\n\r\n12 rows selected.<\/pre>\n
      Scenario 4:<\/strong><\/span><\/h2>\n
      For this scenario, now I will enable some other Buffer Cache pools like 2k\/4k\/recycle\/keep\/etc. As before, the parameters are all the same of scenario 3 plus:<\/p>\n
      alter system set db_recycle_cache_size=10M scope=spfile;\r\nalter system set db_keep_cache_size=10M scope=spfile;\r\nalter system set db_2k_cache_size=10M scope=spfile;\r\nalter system set db_4k_cache_size=10M scope=spfile;\r\nalter system set db_16k_cache_size=10M scope=spfile;\r\nalter system set db_32k_cache_size=10M scope=spfile;\r\nalter system set sga_target=600M scope=spfile;<\/pre>\n
      Let’s check the views:<\/p>\n
      \"\"<\/p>\n
      No surprise here. Let’s check latter how we can match those lines with other views:<\/p>\n
      \"\"<\/p>\n
      v$sga<\/span> and v$sgainfo<\/span> have a direct match as before (expect for Variable Size<\/strong> of v$sga<\/span>).<\/p>\n
      \"\"<\/p>\n
      And the same strange behavior regarding shared_io_pool<\/span><\/strong> again for v$sgastat<\/span>.<\/p>\n
      \"\"<\/p>\n
      Now for v$memory_dynamic_components<\/span> things get more excited. Note that the yellow lines that represents segments in Buffer Cache are nor more divided. We need to SUM all the “* buffer cache<\/strong>” and Shared IO Pool<\/strong> to have a match with Buffer Cache Size of v$sgainfo:<\/span><\/p>\n
      Buffer Cache<\/strong> in v$sgainfo<\/span> = 226492416<\/p>\n
      “* buffer cache<\/strong>” and Shared IO Pool<\/strong> in v$memory_dynamic_components = 12582912 + 12582912 + 12582912 + 12582912 + 109051904 + 12582912 + 12582912 + 41943040 = 226492416<\/p>\n
      And what about v$sga<\/span> Variable Size<\/strong>? It’s almost again the SUM of purples for either v$sgastat<\/span>, v$sgainfo<\/span> or v$memory_dynamic_components<\/span>:<\/p>\n
      Variable Size<\/strong> = 289408088<\/p>\n
      Purple = 12582912 + 20971520 + 222298112 + 33554432 = 289406976<\/p>\n
      The difference (289408088 – 289406976) dropped now to 1112 bytes<\/strong> = 139 Kbytes
      \n<\/strong><\/p>\n
      New conclusions:<\/strong><\/span><\/p>\n
        \n
      1. The new difference between the Variable Size<\/strong> and the actual pools dropped from 290 Kbytes to 139 Kbytes.<\/li>\n<\/ol>\n
        Raw output:<\/p>\n
        SQL> select * from v$sga order by 1;\r\n\r\nNAME                      VALUE     CON_ID\r\n-------------------- ---------- ----------\r\nDatabase Buffers      226492416          0\r\nFixed Size              2927528          0\r\nIn-Memory Area        104857600          0\r\nRedo Buffers            5459968          0\r\nVariable Size         289408088          0\r\n\r\nSQL> select * from v$sgainfo order by 1;\r\n\r\nNAME                                  BYTES RES     CON_ID\r\n-------------------------------- ---------- --- ----------\r\nBuffer Cache Size                 226492416 Yes          0\r\nData Transfer Cache Size                  0 Yes          0\r\nFixed SGA Size                      2927528 No           0\r\nFree SGA Memory Available                 0              0\r\nGranule Size                        4194304 No           0\r\nIn-Memory Area Size               104857600 No           0\r\nJava Pool Size                     12582912 Yes          0\r\nLarge Pool Size                    20971520 Yes          0\r\nMaximum SGA Size                  629145600 No           0\r\nRedo Buffers                        5459968 No           0\r\nShared IO Pool Size                41943040 Yes          0\r\nShared Pool Size                  222298112 Yes          0\r\nStartup overhead in Shared Pool   131422720 No           0\r\nStreams Pool Size                  33554432 Yes          0\r\n\r\n14 rows selected.\r\n\r\nSQL> select component, current_size, user_specified_size, con_id from v$memory_dynamic_components order by 1;\r\n\r\nCOMPONENT                                                        CURRENT_SIZE USER_SPECIFIED_SIZE     CON_ID\r\n---------------------------------------------------------------- ------------ ------------------- ----------\r\nASM Buffer Cache                                                            0                   0          0\r\nDEFAULT 16K buffer cache                                             12582912            12582912          0\r\nDEFAULT 2K buffer cache                                              12582912            12582912          0\r\nDEFAULT 32K buffer cache                                             12582912            12582912          0\r\nDEFAULT 4K buffer cache                                              12582912            12582912          0\r\nDEFAULT 8K buffer cache                                                     0                   0          0\r\nDEFAULT buffer cache                                                109051904                   0          0\r\nData Transfer Cache                                                         0                   0          0\r\nIn-Memory Area                                                      104857600           104857600          0\r\nKEEP buffer cache                                                    12582912            12582912          0\r\nPGA Target                                                          314572800           314572800          0\r\nRECYCLE buffer cache                                                 12582912            12582912          0\r\nSGA Target                                                          629145600           629145600          0\r\nShared IO Pool                                                       41943040            41943040          0\r\njava pool                                                            12582912            12582912          0\r\nlarge pool                                                           20971520            20971520          0\r\nshared pool                                                         222298112                   0          0\r\nstreams pool                                                         33554432            33554432          0\r\n\r\n18 rows selected.\r\n\r\nSQL> select nvl(pool,name) pool, sum(bytes), con_id from v$sgastat group by nvl(pool,name), con_id order by 1,3,2;\r\n\r\nPOOL                       SUM(BYTES)     CON_ID\r\n-------------------------- ---------- ----------\r\nbuffer_cache                184549376          0\r\nfixed_sga                     2927528          0\r\njava pool                    12582912          0\r\nlarge pool                   20480000          0\r\nlarge pool                     491520          1\r\nlog_buffer                    5459968          0\r\nshared pool                   5184240          0\r\nshared pool                 201543320          1\r\nshared pool                   6800384          2\r\nshared pool                   8770168          3\r\nshared_io_pool               41943040          0\r\nstreams pool                 33554432          0\r\n\r\n12 rows selected.<\/pre>\n
        Scenario 5:<\/span><\/strong><\/h2>\n
        For the last scenario, I will now define each SGA component size individually and check what happens. Again, the same parameters as before plus:<\/p>\n
        alter system reset sga_target scope=spfile;\r\nalter system set db_cache_size=100M scope=spfile;\r\nalter system set shared_pool_size=200M scope=spfile;<\/pre>\n
        Checking the views:<\/p>\n
        \"\"<\/p>\n
        Nothing special changed in v$sga<\/span>.<\/p>\n
        \"\"<\/p>\n
        Nothing special changed in v$sgainfo<\/span>.<\/p>\n
        \"\"<\/p>\n
        Nothing special changed in v$sgastat<\/span>.<\/p>\n
        \"\"<\/p>\n
        Lastly, let’s check if the difference among Variable Size<\/strong> of v$sga and SGA pools have changed.<\/span><\/span><\/p>\n
        Variable Size<\/strong> = 289408376<\/p>\n
        Purple = 12582912 + 20971520 + 222298112 + 33554432 = 289406976<\/p>\n
        The difference (289408376 – 289406976) increased now to 1400 bytes<\/strong> = 175 Kbytes<\/strong><\/p>\n
        New conclusions:<\/strong><\/span><\/p>\n
          \n
        1. The new difference between the Variable Size<\/strong> and the actual pools increased from 139 Kbytes to 170 Kbytes.<\/li>\n<\/ol>\n
          Raw output:<\/p>\n
          SQL> select * from v$sga order by 1;\r\n\r\nNAME                      VALUE     CON_ID\r\n-------------------- ---------- ----------\r\nDatabase Buffers      209715200          0\r\nFixed Size              2927240          0\r\nIn-Memory Area        104857600          0\r\nRedo Buffers            5459968          0\r\nVariable Size         289408376          0\r\n\r\nSQL> select * from v$sgainfo order by 1;\r\n\r\nNAME                                  BYTES RES     CON_ID\r\n-------------------------------- ---------- --- ----------\r\nBuffer Cache Size                 209715200 Yes          0\r\nData Transfer Cache Size                  0 Yes          0\r\nFixed SGA Size                      2927240 No           0\r\nFree SGA Memory Available                 0              0\r\nGranule Size                        4194304 No           0\r\nIn-Memory Area Size               104857600 No           0\r\nJava Pool Size                     12582912 Yes          0\r\nLarge Pool Size                    20971520 Yes          0\r\nMaximum SGA Size                  612368384 No           0\r\nRedo Buffers                        5459968 No           0\r\nShared IO Pool Size                41943040 Yes          0\r\nShared Pool Size                  222298112 Yes          0\r\nStartup overhead in Shared Pool   127957928 No           0\r\nStreams Pool Size                  33554432 Yes          0\r\n\r\n14 rows selected.\r\n\r\nSQL> select component, current_size, user_specified_size, con_id from v$memory_dynamic_components order by 1;\r\n\r\nCOMPONENT                                                        CURRENT_SIZE USER_SPECIFIED_SIZE     CON_ID\r\n---------------------------------------------------------------- ------------ ------------------- ----------\r\nASM Buffer Cache                                                            0           104857600          0\r\nDEFAULT 16K buffer cache                                             12582912            12582912          0\r\nDEFAULT 2K buffer cache                                              12582912            12582912          0\r\nDEFAULT 32K buffer cache                                             12582912            12582912          0\r\nDEFAULT 4K buffer cache                                              12582912            12582912          0\r\nDEFAULT 8K buffer cache                                                     0                   0          0\r\nDEFAULT buffer cache                                                 92274688            92274688          0\r\nData Transfer Cache                                                         0                   0          0\r\nIn-Memory Area                                                      104857600           104857600          0\r\nKEEP buffer cache                                                    12582912            12582912          0\r\nPGA Target                                                          314572800           314572800          0\r\nRECYCLE buffer cache                                                 12582912            12582912          0\r\nSGA Target                                                                  0                   0          0\r\nShared IO Pool                                                       41943040            41943040          0\r\njava pool                                                            12582912            12582912          0\r\nlarge pool                                                           20971520            20971520          0\r\nshared pool                                                         222298112           222298112          0\r\nstreams pool                                                         33554432            33554432          0\r\n\r\n18 rows selected.\r\n\r\nSQL> select nvl(pool,name) pool, sum(bytes), con_id from v$sgastat group by nvl(pool,name), con_id order by 1,3,2;\r\n\r\nPOOL                       SUM(BYTES)     CON_ID\r\n-------------------------- ---------- ----------\r\nbuffer_cache                167772160          0\r\nfixed_sga                     2927240          0\r\njava pool                    12582912          0\r\nlarge pool                   20971520          0\r\nlog_buffer                    5459968          0\r\nshared pool                   9369744          0\r\nshared pool                 198289040          1\r\nshared pool                   6500608          2\r\nshared pool                   8138720          3\r\nshared_io_pool               41943040          0\r\nstreams pool                 33554432          0\r\n\r\n11 rows selected.<\/pre>\n
          Conclusion:<\/strong><\/span><\/h2>\n
          After these 5 tests, I came with 3 major conclusions:<\/p>\n
            \n
          1. The Shared IO Pool<\/strong><\/span> is part of Buffer Cache<\/strong> accordingly to v$sgastat<\/span> and v$memory_dynamic_components<\/span> views. v$sga<\/span> put it also in Database Buffers<\/strong>, not in Variable Size<\/strong>.<\/span><\/span> v$sgainfo<\/span> show them separated.<\/li>\n
          2. The Variable Size<\/strong> of v$sga<\/span> is the sum of Large Pool, Java Pool, Streams Pool and Shared Pool (not Shared IO Pool). If AMM is enabled, it also includes PGA.<\/li>\n
          3. There is very small difference (350 Kbytes is the highest I got) in Variable Size<\/strong> to match it with the pools. I would love to understand why this difference is not exactly zero. If anyone knows please share.<\/li>\n<\/ol>\nHave you enjoyed? Please leave a comment or give a \ud83d\udc4d!<\/b>\n
            <\/object><\/p>\n
            <\/object><\/p>\n
            <\/object><\/p>\n
            <\/object><\/p>\n
            <\/object><\/p>\n
            <\/object><\/p>\n
            <\/object><\/p>\n
            <\/object><\/p>\n
            <\/object><\/p>\n
            Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-2890","post","type-post","status-publish","format-standard","hentry","category-database-en","item-wrap"],"yoast_head":"\nv$sga, v$sgainfo and v$sgastat matching bytes challenge - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"Correlating the lines returned by a select star from v$sga, v$sgainfo and v$sgastat.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbarj.com.br\/en\/2017\/10\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/10\\\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/10\\\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"v$sga, v$sgainfo and v$sgastat matching bytes challenge\",\"datePublished\":\"2017-10-18T12:50:34+00:00\",\"dateModified\":\"2017-10-18T16:14:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/10\\\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\\\/\"},\"wordCount\":1316,\"commentCount\":9,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/10\\\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/AMM-Pic1.png\",\"articleSection\":[\"Oracle Database General\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/10\\\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/10\\\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/10\\\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\\\/\",\"name\":\"v$sga, v$sgainfo and v$sgastat matching bytes challenge - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/10\\\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/10\\\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/AMM-Pic1.png\",\"datePublished\":\"2017-10-18T12:50:34+00:00\",\"dateModified\":\"2017-10-18T16:14:59+00:00\",\"description\":\"Correlating the lines returned by a select star from v$sga, v$sgainfo and v$sgastat.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/10\\\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/10\\\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/10\\\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\\\/#primaryimage\",\"url\":\"http:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/AMM-Pic1.png\",\"contentUrl\":\"http:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2017\\\/10\\\/AMM-Pic1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/10\\\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"v$sga, v$sgainfo and v$sgastat matching bytes challenge\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"v$sga, v$sgainfo and v$sgastat matching bytes challenge - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Correlating the lines returned by a select star from v$sga, v$sgainfo and v$sgastat.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbarj.com.br\/en\/2017\/10\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"15 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2017\/10\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/10\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"v$sga, v$sgainfo and v$sgastat matching bytes challenge","datePublished":"2017-10-18T12:50:34+00:00","dateModified":"2017-10-18T16:14:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/10\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\/"},"wordCount":1316,"commentCount":9,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"image":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/10\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\/#primaryimage"},"thumbnailUrl":"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2017\/10\/AMM-Pic1.png","articleSection":["Oracle Database General"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2017\/10\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2017\/10\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\/","url":"https:\/\/www.dbarj.com.br\/en\/2017\/10\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\/","name":"v$sga, v$sgainfo and v$sgastat matching bytes challenge - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/10\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\/#primaryimage"},"image":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/10\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\/#primaryimage"},"thumbnailUrl":"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2017\/10\/AMM-Pic1.png","datePublished":"2017-10-18T12:50:34+00:00","dateModified":"2017-10-18T16:14:59+00:00","description":"Correlating the lines returned by a select star from v$sga, v$sgainfo and v$sgastat.","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/10\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2017\/10\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/en\/2017\/10\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\/#primaryimage","url":"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2017\/10\/AMM-Pic1.png","contentUrl":"http:\/\/www.dbarj.com.br\/wp-content\/uploads\/2017\/10\/AMM-Pic1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2017\/10\/vsga-vsgainfo-and-vsgastat-matching-bytes-challenge\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"v$sga, v$sgainfo and v$sgastat matching bytes challenge"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/2890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=2890"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/2890\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=2890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=2890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=2890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}