Hi Michael,
the value is calculated at startup (mostly based on CPU_COUNT and
SHARED_POOL_SIZE). Why do you want to change it?
In the first code versions (started with 9i) there was a design flaw, that a
process gonna request memory from just one sub-pool and if not enough
contiguous free memory was available in that sub-pool you received an
ORA-04031, even if there were enough available chunks in the other sub-pools.
But this has improved a lot - so usually no need to fiddle with this parameter
(e.g. like setting it to 1).
However the maximum are 7 sub-pools (as protected by 7 separate shared pool
latches). Some time ago i asked Tanel about the mapping of the latches and
sub-pools - details can be found in this Tweet:
https://twitter.com/OracleSK/status/595909279481274368
Finally don't forget about the durations. The amount/usage of durations also
has changed with Oracle 12c - for details please check this blog post:
https://mahmoudhatem.wordpress.com/2015/04/22/oracle-12c-shared-pool-and-durations-enhancement/
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: @OracleSK
Michael Calisi <oracle455@xxxxxxxxx> hat am 28. August 2015 um 20:21
geschrieben:
How many subpools do you have as a default ?
_kghdsidx_count"= Wondering what's the best way to determine setting this
parameter running Oracle 11.2.0.4.0