Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Finding Shared_pool_size

Hello experts,
I have difficulties in finding the size of Shared_pool_size. Is it from v$sgastat or from v$parameter ?
The queries from both parameters gives out different results.
For v$sgastat, I get 5.6 GB. The query i use :
SELECT pool, sum(bytes)/1024/1024/1024 FROM v$sgastat
WHERE pool = 'shared pool' GROUP BY pool;
Just incase you need the free shared pool, I get 2.3 GB. The query for free shared pool :
SELECT * FROM v$sgastat
WHERE name = 'free memory' AND pool = 'shared pool';
Whereas, for shared pool using v$parameter, I get 2.9 GB. The query i use :
select NAME, VALUE/1024/1024/1024 from v$parameter where name='shared_pool_size';
I am using Oracle 11.2 G with AMM enabled, with SGA_TARGET 14 GB and MEMORY_TARGET 26 GB.
thanks for any advice.
Answers
-
Isn't this just a continuation of your earlier thread?