HELP!! Is large_pool_size part of Shared_pool_size????

[chrissy]

Is large_pool_size part of Shared_pool_size????

[karthiarun]

No large_pool_size is a part of shared pool size in oracle 8i. I dont know about the previous versions of oracle. But it is definitely not a part of shared pool size.

Karthi

[Tee]

Yes. Large Pool is part of the shared pool. The shared pool can be found in the SGA. And inside the shared pool, you will find the large pool, library cache, shared pool reserve size(that is if it has been defined) and the dictionary cache.
So to answer your question, large pool is definately in the shared Pool.

If any one disagrees, I can explain some more.

NOTE: THIS IS ONLY in 8i

[Oracledba8]

Don't Fight.

Here is one example


1 select rpad(name,25) name, rpad(description,50) description
2 from v$parameter
3* where name like '%pool%'
SQL> /

NAME DESCRIPTION
========================= ==================================================
shared_pool_size size in bytes of shared pool
shared_pool_reserved_size size in bytes of reserved area of shared pool
large_pool_size size in bytes of the large allocation pool
java_pool_size size in bytes of the Java pool
buffer_pool_keep Number of database blocks/latches in keep buffer p
buffer_pool_recycle Number of database blocks/latches in recycle buffe


Thanks

[rohitsn]

Hi,
This is Rohit Nirkhe,OCP from India.Large pool is not a part of Shared pool.Large pool basically is used for backup and recovery using RMAN.
A large pool is created only when u set the init.ora parameter
LARGE_POOL_SIZE=n
If u dont set the parameter ,large pool is not created.
When u configure the large pool,there is an increase in the size of SGA.So the new size of SGA becomes

database buffer cache+shared pool + redo log buffer +
large pool

If u have any doubts ,please be free to ask me at rohitsn@hotmail.com



[QUOTE][i]Originally posted by chrissy [/i]
[B]Is large_pool_size part of Shared_pool_size???? [/B][/QUOTE]