HELP!! Is large_pool_size part of Shared_pool_size????
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

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

  1. #1
    Join Date
    Oct 2000
    Posts
    56
    Is large_pool_size part of Shared_pool_size????

  2. #2
    Join Date
    Feb 2001
    Posts
    40

    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

  3. #3
    Join Date
    Feb 2001
    Posts
    32
    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



  4. #4
    Join Date
    Feb 2001
    Posts
    184
    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

  5. #5
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    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
  •  


Click Here to Expand Forum to Full Width