-
Is large_pool_size part of Shared_pool_size????
-
Hi
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
karthi,
MDC Systems inc
Farmington Hills,MI
-
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
-
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
-
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]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|