This email caught my eyes browsing through 100s of unread ORACLE-L email. I didn't find any answer to this question so decided to reply. Boris, The value of _kghsidx_count is dependent on 2 factors. One is the size of shared pool and the other is CPU. Not sure if this algorithm is absolutely right, but it is close. _kghsidx_count =3D ROUND ( LEAST ( No. Of CPUs / 4, Shared Pool (in MB)/ 128 ) ) Naveen -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Boris Dali Sent: Monday, November 08, 2004 10:11 PM To: tanel.poder.003@xxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: Re: x$kghlu, Steve's shared_pool_lru_stats I toyed around with the size of the shared pool in the attempt to get 3 heaps, but to no avail. Even setting shared_pool_size to 20GB didn't produce 3 heaps. Just curious how does one get 7? Also a more practical question (I think). If my "optimal" shared pool size is around 250MB (i.e. at 150-200MB I get ORA-4031), would I be better off with 240MB and a single heap or at 250MB and dual heaps? Thanks, Boris Dali. This message (including any attachments) contains confidential = information intended for a specific individual and purpose, and is = protected by law. If you are not the intended recipient, you should = delete this message. Any disclosure, copying, or distribution of this = message, or the taking of any action based on it, is strictly = prohibited. -- //www.freelists.org/webpage/oracle-l