DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: large pool size

  1. 10-14-2002, 04:19 AM #1
    Paul H
    Paul H is offline Junior Member
    Join Date
    Oct 2000
    Posts
    57
    Oracle 8.1.7 what is the minimum large pool size can be set to? im not using multi threaded server on this database??

    platform windows 2000 sp2
    Reply With Quote Reply With Quote
  2. 10-14-2002, 05:03 AM #2
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    The minimum size for the large pool is zero.
    The large pool is not only used for MTS but some other oprations as well e.g. RMAN. So consider them before you set it to zero.

    Sanjay
    Reply With Quote Reply With Quote
  3. 10-14-2002, 05:20 AM #3
    Paul H
    Paul H is offline Junior Member
    Join Date
    Oct 2000
    Posts
    57
    thank you Sanjay
    Reply With Quote Reply With Quote
  4. 10-14-2002, 05:26 AM #4
    Calvin_Qiu's Avatar
    Calvin_Qiu
    Calvin_Qiu is offline Senior Member
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    and also for parallel query if it's configurated.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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