DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: ORA-04030

  1. #11
    Join Date
    Jun 2000
    Posts
    104
    sort_area_size=1048576bytes

  2. #12
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    decrease that value to 128K, what platform is this? 8i?

  3. #13
    Join Date
    Jun 2000
    Posts
    104
    yes 8i,do u think I should include large pool size =20m in init.ora,which will increase the sga further and as memory error is there ???//

  4. #14
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Well I dont think it´s related to SGA, it is related to PGA so leave SGA intact, if it was 4031 then it is SGA problem but it isnt.

  5. #15
    Join Date
    Jun 2000
    Posts
    104
    hi, thanks for so fast reply,but whether to include largepool in init.ora or not .presently it is set to 0.and i am using mts.so should i increase large pool size or not.

  6. #16
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Set large pool to 10M, if you get 4031 in the future increase it <g>

  7. #17
    Join Date
    Jun 2000
    Posts
    104
    thank you pando for so much help

    regards

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