Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle on Windows 2000 AS with /3GB flag

Re: Oracle on Windows 2000 AS with /3GB flag

From: Richard Saints <>
Date: Tue, 17 Jul 2007 23:13:40 +0100
Message-ID: <>

Hi Kathy,
thanks for your feedback.

What do you mean by "Watch out for hyperthreading on cpus" ? The test system that failed to start the database has 2 CPUs on hyperthreading mode.

I was planning to activate /3GB because I want to increase the value allocated to the SGA (currently 1336MB). And I would like to continue to use ASMM (Automatic Shared Memory Management).

I started to read your metalink article and I had a feeling of "deja-vu".

I also would like to thank everyone of the list who gave me some feedback.

Best Regards,

On 7/17/07, kathy duret <> wrote:
> Check Metalink. You will find all sorts of docs on /3G
> I am surprised to hear it didn't work on the test system.
> Watch out for hyperthreading on cpus. This affects alot of hidden
> parameters.
> I had to take off the auto sga and decrease my sga target quite a bit.
> No not applicable on 64 bit Windows.
> I did have issues with /PAE switch and performance.
> --- Shamless self promotion....
> You might want to check out my article on turning my windows woes into wow
> article
> on Metalink. I had alot of Windows issues I needed to work through.
> I am working with Orakill now to kill session vs using alter session kill.
> I found on windows killing sessions didn't always work and orakill does.
> I will add my orakill info to my article next week hopefully.
> Kathy
> *Richard Saints <>* wrote:
> Hello to you all,
> I'm planning to activate the /3GB flag on a Windows server running Oracle
> Database, in order to extend the memory that can be used by Oracle.
> The server has the following characteristics:
> HP Proliant DL380
> 2 x Pentium Xeon 3,2 GHz
> 4 GB of RAM
> HP Smart Array SCSI controller
> 2x36GB SCSI RAID 1 internal discs with 2 logical drives:
> C drive for OS
> D drive for Logs
> 4x146 GB SCSI RAID 5 internal discs with 1 logical drive:
> F drive for data
> Paging size on C drive (2048-4096)
> SO: Windows 2000 Advanced Server SP4
> The Oracle SGA Target is 1336 MB
> I would like to know if there is any special care that I should take,
> before I activate this flag on boot.ini.
> I read the Oracle Documentation, but I didn't found any particular aspect.
> I'm asking this because I had a bad experience with a test server where
> with the /3G flag was activated and the Oracle instance didn't startup. I
> still haven't figured out why.
> Thanks for all your attention.
> Best Regards,
> Ricardo.
> ------------------------------
> Boardwalk for $500? In 2007? Ha!
> Play Monopoly Here and Now<*>(it's updated for today's economy) at Yahoo! Games.

Received on Tue Jul 17 2007 - 17:13:40 CDT

Original text of this message