- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
How to see the real SHARED POOL being used ?
I am having problem in determining the size of Shared Pool. I want to know the utilization of the shared pool as mention here : (https://docs.oracle.com/cd/B16240_01/doc/doc.102/e16282/oracle_database_help/oracle_database_sga_pool_wastage_shared_free_pct.html)
When I use query : "SELECT pool, sum(bytes)/1024/1024/1024 AS "Size (GB)" FROM v$sgastat WHERE pool = 'shared pool' GROUP BY pool;"
select sum(bytes)/1024/1024/1024 AS "Size (GB)" from v$sgastat where pool = 'shared pool'
It gives me : 2.7 GB.
But, when I use : "select component, current_size, max_size, granule_size, last_oper_type
from v$memory_dynamic_components;", it gives me 6,106,906,624 (I assume this is in Bytes, so it is equal to 5.6875 GB).
Questions are :
- What are the differences between the 2 queries ? Why differ almost twice between v$sgastat and v$memory_dynamic_components
- For each one, Which query should I use for what ?
- For my case in determining the utilization of memory, which one should i use ?
This is confusing to me
Please help me.