| vasu |
Posted: Apr 27, 2003 12:58:00 PM |
Total Post: 50
Joined: Jan, 2003
|
Hi All,
Can you please explain the use of LARGE_POOL_SIZE parameter? Is this used only in shared server configuration?
Thanks.
|
|
|
 anjali |
| Posted: Jan 20, 2004 05:11:33 AM |  |
|
Total Post: 2
Joined: Jan, 2003
|
yes it is used in shared server mode only. in shared server mode the session information,cursor information goes to shared pool & is not there with pga. so to better tune shared pool we need to configure large pool whose size is set from parameter large_pool_size
|
|
|
|
|
| vasu |
| Posted: Jan 20, 2004 10:08:36 AM | |
|
Total Post: 50
Joined: Jan, 2003
|
Thanks for reply.
It means it is not necessary to allocate large pool size in shared server as it can take memory from shared pool.
Thanks,
Vasu
|
|
|
|
|
| Deepak |
| Posted: Oct 02, 2005 11:31:25 AM | |
|
Total Post: 10
Joined: Mar, 2005
|
Hi Vasu,
as u asked for Lard_pool_size, this may be used in any mode i.e. Shaerd server mode or Dedicated mode. This is optional and generally used for large operations i.e. RMAN, long running batch process.Java_pool is also optional and used for java objects to be stored in memory at run time.
Large_pool_size is configured just to avoid the fall in hit ratio.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
