DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5
  1. #1
    Join Date
    May 2009

    Very Large Memory (VLM) Configuration

    Help me maintain my sanity please.

    There were memory issues with our internally written application running a batch job. They, proj mgr and business consultant, asked me to implement /3GB switch. There is some confusion about how this should be implemented. I thought that you had to make changes to the O/S on the database server by editing the boot.ini file and make changes to some of the Oracle database parameters. The proj mgr and business consultant feel that you only have to make changes to the O/S on the client machine by editing the boot.ini where the application is stored. I'm outnumbered 2 to 1 so the latter solution has prevailed. What is correct?

    Thanks in advance.


  2. #2
    Join Date
    Sep 2002
    if all they wanted was the 3Gb switch, then they are correct

    you need to define what you actually want, no point asking random people on the internet what your colleagues mean

  3. #3
    Join Date
    May 2009
    What does the /3GB switch give you on the client machine. The problem reported was with the Database Query during a batch job?



  4. #4
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    Quote Originally Posted by pengwen View Post
    The problem reported was with the Database Query during a batch job?
    Is there any specific Oracle error or out of the ordinary behavior? what's the problem?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Nov 2000
    Pittsburgh, PA
    Just to be pedantic, the /3GB switch relates to trying to get 32 bit windows servers to address 3GB of ram. You can't get a 32 bit windows server to address more than 3GB of ram. Depending on what needs the extra memory and what you SGA is set to, you may or may not need to adjust the SGA.
    this space intentionally left blank

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