DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2000
    Pune, India

    Memory fragmentation or Windows limitation?


    RDBMS Version:
    Operating System and Version: Windows 2000 Advanced Server

    All OS and Server version details are mentioned above, although single instance can take 2GB of memory on Windows, when Oracle.exe reaches 1.7GB, we start getting this error. Total SGA size is 1.1 GB, 400 sessions and dedicated server mode. So initially we reduced SGA size by reducing DB_BUFFER_CACHE. But again hit same error...

    TNS-12500: TNS:listener failed to start a dedicated server process
    TNS-12540: TNS:internal limit restriction exceeded
    TNS-12560: TNSrotocol adapter error
    TNS-00510: Internal limit restriction exceeded
    32-bit Windows Error: 8: Exec format error

    Now we have inserted /3 GB parameter in boot.ini and also reduced SGA by 100 MB. In long term we are planning to use Multi Threaded server. What else can be done to avoid this error? Is this windows issue of memory fragmentation when application sessions are connected and disconnected frequently? please help us.

    Thanks & Regards,


  2. #2
    Join Date
    Sep 2002
    32Bit oracle is restricted to an SGA of 1.75Gb, any more and you will get errors (you can go up to 3Gb is you set some boot.ini parameters as you have done)

    Dont forget that the OS needs memory as well, you may well be blowing all your machines resources

    Are you using a lot of PGA as well?

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.