How to detemine LARGE_POOL_SIZE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to detemine LARGE_POOL_SIZE

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    224
    What factor needs to be considerd in detemining LARGE_POOL_SIZE.

    I am using RMAN for Backup and Shared Server process (Multi Threaded Architecture).

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    The two you mentioned: using RMAN for backup and MTS. It is not required, but is recommended if you are using either of the above. If you don't use it, memory for user sessions and RMAN backup is allocated from the shared pool, which in turn may cause fewer SQL statements to be cached.

    Default size is zero. Minimum size is 600K. Max size is OS dependent, but will be at least 2GB.

    From Oracle8i DBA Bible by Gennick.

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by Sharma
    What factor needs to be considerd in detemining LARGE_POOL_SIZE.

    I am using RMAN for Backup and Shared Server process (Multi Threaded Architecture).
    There is a formula suggested by Oracle:

    LARGE_POOL_SIZE = (4 * {RMAN Channels} * {DB_BLOCK_SIZE} * {DB_DIRECT_IO_COUNT} * {Multiplexing Level}) + (4 * {RMAN Channels} * {Tape Buffer Size})

    In real life, 20-100M will do the job. I use RMAN and set it to 32M :-)
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    to calculate MTS

    get average session uga memory max from all sessions and multiply the number of sessions you think you will have

  5. #5
    Join Date
    Nov 2000
    Posts
    224
    As LARGE POOL don't uses LRU algorithm,
    What should I be doing to avoid ORA-4031, will Oracle releases memory from LARGE POOL once the session dis connects.
    How LARGE POOL space is released once the RMAN backup is over.
    What should be the value LARGE_POOL_MIN_ALLOC, as I read somewhere, each active session needs around 300KB, should I set it close to this no.

    Please advise.
    Thanks!


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