v$sgastat might be of some interest to you On Mon, 3 Jan 2005 12:26:11 +0300, Jaffar_DBA <sjaffarhussain@xxxxxxxxx> wrote: > Hello list, > > Can any one explain me that when I assign 608M size to > shared_pool_size how much is allocated between library cache & > dictionary cache. -- //www.freelists.org/webpage/oracle-l